usp_tableReference

  • Ankush Parab

    SSC Veteran

    Points: 239

    Comments posted to this topic are about the item usp_tableReference

  • feroz.durani

    SSC Rookie

    Points: 43

    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: 239

    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

    Thanks for the script.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply