InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 05:08:10 GMT20http://www.sqlservercentral.com/Forums/Topic732064-338-1.aspxIt could be you have to qualify the object if schema is NOT dbo.Supposing you have the Adventureworks db attached, you should get results with this:[i]exec sp_depends 'person.contact'[/i]If not, then I don't know what could be wrong; if you do, then this sp works and it may mean your object has no dependencies.Wed, 10 Jun 2009 06:52:03 GMTFreeHansjehttp://www.sqlservercentral.com/Forums/Topic732064-338-1.aspxHi Hans,thanks for update.its not working in my database .it is not returning anything after giving the sp name.RegardsAmitWed, 10 Jun 2009 04:47:30 GMTamittheminghttp://www.sqlservercentral.com/Forums/Topic732064-338-1.aspxYou use sp_depends 'ObjectName'. This will get you all dependanciesIf you wish to tailor the output to your specific needs place it in a (temporary) table.Mind, there are other ways to find dependencies, not all dependencies can be found like above. Have a read:[url]http://www.mssqltips.com/tip.asp?tip=1294[/url]Wed, 10 Jun 2009 04:31:56 GMTFreeHansjehttp://www.sqlservercentral.com/Forums/Topic732064-338-1.aspxHi All,Can abyone help me to create a script that will tell me what all object (table,views) are dependent on a particular stored procedure.Thanks in advanceWed, 10 Jun 2009 01:27:42 GMTamittheming