The SQL server profiler is a great tool for tracing and debugging database transactions, stored procedure execution etc. To trace the goings on inside a stored procedure it’s always best to use the TSQL_SPs template as this will provide much more detail than the standard template. Depending on the amount database activity, separating the wheat from theRead more about Filtering tip for SQL Server Profiler[…]

Viewing table dependencies will show you what SP’s depend on the table, but what if you need to find those SP’s which only reference a single field. The following queries will provide you with a list of SP’s which contain the reference you are searching for. SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE ‘%look for me%’Read more about How to search all Stored Procedures for a reference[…]

To suppress the rows affected message from printing use the following TSQL statement: SET NOCOUNT ON