Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Proc to Query Syscomments and Sysobjects

By jackdonnell, 2013/05/23

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: 605 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Routine Dependency Visualizer

This article contains a T-SQL script that can show you the dependency of all objects in your SQL Ser...

BLOG

SQL Server Object Dependency Viewer Revisited

A year ago I blogged about building a SQL Server 2008 Object Dependency Viewer based on a script by ...

FORUM

Sequence of Database Objects Dependency - SQL 2005

Sequence of Database Objects Dependency - SQL 2005

FORUM

sp to object dependencies

a script which will tell odject depending on a sp

BLOG

Find Dependencies

Here's a script from my toolbox I use to find dependencies between SQL objects.  The where clause ha...

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones