Thursday, November 29, 2012

SQL Server: Script to Find Tables in Stored Procedures, That Are Without NonClustered Index

From my query bank here is another useful script which can help a Database Administrator to list down stored procedures with tables names which are used in stored procedures but don't contain and non clustered index.

Query Output:

2 comments:

  1. Helpful Script....

    ReplyDelete
  2. What if there is no entry for an object in sysdepends?

    ReplyDelete

All suggestions are welcome