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
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 [...]