View Dependencies via ssms

• TST1

  SSCommitted

  Points: 1798

  More actions

  January 12, 2012 at 3:38 am

  #262810

  Hi,

  I am unable to view dependencies on tables if I right click on a table via ssms. But if I run sp_depends I can get the information. Is there a bug in ssms?

  Thanks

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 12, 2012 at 4:56 am

  #1432372

  Check this

  http://www.mssqltips.com/sqlservertip/1294/listing-sql-server-object-dependencies/

• TST1

  SSCommitted

  Points: 1798

  More actions

  January 12, 2012 at 5:09 am

  #1432377

  Thanks for this but my developers are getting frustrated as they can't seem to do this via ssms gui. No errors

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  January 15, 2012 at 6:13 am

  #1433813

  It might be permission issue. It’s a DEV environment & I don’t believe much restrictions are required, try giving them appropriate permissions so they can query on system tables / views.