Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Procedure proc_FilltblUnusedIndexes (Manage Indexes) Expand / Collapse
Author
Message
Posted Tuesday, October 20, 2009 8:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 27, 2014 12:53 AM
Points: 68, Visits: 412
Please check that table tblIndexUsageInfo does not have a field by the name IndexSelectionCrieteria
which you used on the UNION. If it is not a mistake please can you ALTER the Table and show us the value of the column? Otherwise the whole process is very neat. Procedure proc_FilltblUnusedIndexes (Manage Indexes)
Post #805748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse