Proc to Query Syscomments and Sysobjects

Total article views: 352 | Views in the last 30 days: 8

 Rate this |   Join the discussion |  Briefcase

TSQL:Procedure to Query for Dependent Objects

Jack Donnell,
jack@JackDonnell.com

Have you ever kept altering the same query to look for different items in you database?
I took a hint from MS with all the sp_help and other system stored procedures and made
a two scripts this one to query for databases dependednt objects or references.

I also created another script to query on msdb..sysjobs and msdb..sysjobsteps for phrase or objects.

Here is the script and make sure you don't grant access to public. I used this as a quick solution
and there are tons of ways to probably improve it. I just need some thing to get me started to
in my search to help Identify certain dependent objects or attributes within syscomments.

It is just a starting place to look for outdated or dependent code references.

Total article views: 352 | Views in the last 30 days: 8