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

792 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

570 reads

Blogs

SQL Saturday Denver 2023–VCS Primer for the Database slides

By

My slides are here: VCS Primer Denver 2023 This was an overview of what...

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Read the latest Blogs

Forums

Delegated rights to Enable/Disable TSQL Jobs (Specific Jobs)

By nathanlbell

All, In attempts thinking that I am smarter than your average bear, I attempted...

Hello i am new to Sql and idk why i get this error and also not getting results.

By imon

CREATE DATABASE dbsubjects; CREATE TABLE tblstudent( ID INTEGER PRIMARY KEY, TheName Varchar (100), TheAddress...

Identifying the process that is backing the databases to virtual device

By ramana3327

We have about 20 SQL Servers. We use Net backup or Native backup for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers