usp_tableReference

• Ankush Parab

  SSC Veteran

  Points: 240

  More actions

  August 11, 2013 at 8:41 am

  #276864

  Comments posted to this topic are about the item usp_tableReference

• feroz.durani

  SSC Rookie

  Points: 43

  More actions

  August 12, 2013 at 8:06 am

  #1640608

  Hi Ankush,

  Pls correct me if i'm wrong....

  Have your tried sp_depends ?

  Note : This feature will be removed in a future version of Microsoft SQL Server.

  Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

  Use sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities instead.

  http://technet.microsoft.com/en-us/library/ms189487.aspx

  Regards,

  Durani

• Ankush Parab

  SSC Veteran

  Points: 240

  More actions

  August 12, 2013 at 8:42 am

  #1640621

  I did try that... On few occasions i did not get accurate results. And it gives results only from one database i believe

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  April 28, 2016 at 7:14 am

  #1875235

  Thanks for the script.