Technical Article

Scan stored procedures in all databases

I wrote this for the developers because they were always asking me to find all of their stored procedures that did X.It scans through the syscomments text in each database looking for the requested string.  User must have read access on the syscomments and sysobjects tables in each database.

You rated this post out of 5. Change rating

2002-06-14

884 reads

Technical Article

System Lock Snapshot

This script captures the current system lock in a temp table, then builds a temp translation table for database and object id by iterating through all of the databases.  It then produces a report by joining the two tables.For better performance, you could make the translation table perminante and only update it when you are […]

You rated this post out of 5. Change rating

2002-06-14

573 reads

Blogs

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Using SQL Compare in Read-Only Databases

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Logging from application to SQL server 2014..Using ODBC driver 18 for SQL SERVER

By SQL_Surfer

I'm using the below connection string using providing UserID and password on their respective...

Knowing Your Total Reward

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Knowing Your Total Reward

No Renames

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Renames

Visit the forum

Question of the Day

No Renames

Which of these can't be renamed with sp_rename?

See possible answers