SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 06/06/2012 :  17:35:20  Show Profile  Reply with Quote
I am looking for a query which should gives object dependencies for the stored procedures.
The objects on which stored procedures depends.

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 06/06/2012 :  17:38:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
sp_depends?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 06/06/2012 :  17:52:02  Show Profile  Reply with Quote
sp_depends doesn't provide the accurate results...

Go to Top of Page

yosiasz
Flowing Fount of Yak Knowledge

USA
1608 Posts

Posted - 06/06/2012 :  17:55:52  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
how about using sys tables

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173827&SearchTerms=sys


<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 06/06/2012 :  17:56:48  Show Profile  Visit robvolk's Homepage  Reply with Quote
Try this instead:
SELECT OBJECT_NAME(referencing_id), * FROM sys.sql_expression_dependencies
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000