SQL script to check table & sp dependencies

• luchuncd

  SSC Enthusiast

  Points: 159

  More actions

  October 31, 2008 at 9:58 am

  #195313

  Hi,

  Anyone know the SQL script to check the table or stored procedure dependencies?

  Best Regards.

• SQLZ

  SSChampion

  Points: 12872

  More actions

  October 31, 2008 at 10:08 am

  #892446

  Check out the stored procedure sp_depends and the dmv sys.sql_dependencies in BOL.

  And make sure to read up on its limitations.

  Karl
  source control for SQL Server

• luchuncd

  SSC Enthusiast

  Points: 159

  More actions

  October 31, 2008 at 10:20 am

  #892454

  Hi SQLZ,

  Thanks for your reply so fast. The sp_depends can work now. But I can't select from the sys.sql_dependencies, S2K prompt "The object 'sql_dependencies' does not exist in database". Could you please tell me how to fix it?

  Thanks a lot.

• SQLZ

  SSChampion

  Points: 12872

  More actions

  October 31, 2008 at 10:42 am

  #892466

  sys.sql_dependencies is only available in SQL 2005 so you're stuck with sp_depends in SQL 2000.

  Karl
  source control for SQL Server

• luchuncd

  SSC Enthusiast

  Points: 159

  More actions

  October 31, 2008 at 11:17 am

  #892482

  Thanks a lot & have a good halloween night. 🙂

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 31, 2008 at 3:02 pm

  #892604

  If you mean, "as in the Show Dependencies task", you use the sys.sql_dependencies system catalog view.

  However, neither is truly reliable.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]