As much as we like to complain about it, Britain’s public transport system is amazing! We can probably get to 90% of the country any day we choose, more often than not at a choice of times throughout the day or night. For many years I have contentedly (or occasionally grudgingly) used this brilliant service [...]
It is really useful to be able to find a table or stored procedure with a particular string in it; and it’s actually really simple. For the example of a Stored Procedure, the contents are stored in INFORMATION_SCHEMA.ROUTINES and also syscomments and either can be queried: SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE ‘%foobar%’ [...]
Continue reading about Searching for a specific string in MSSQL objects
Since I first started going to Indian restaurants I realised the importance beer plays in the enjoyment of a good curry. There’s something about the coolness and crispness of a cold pint of lager which brings out the flavour of the spices whilst cooling the palette long enough to shovel a couple more mounds of [...]
Collation can be set on multiple levels on a server though is principally at the server level and at the column level on tables. If these collations are different, temporary tables created on the Master database will not be able to resolve with those on the database columns and queries will throw an error. Recently [...]