26 Aug 2010
Updated: 26 Aug 2010
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: CPOL
Views: 5,740
Bookmarked: 3
Downloaded: 0
Also use either this one:SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcntFROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.idWHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'or this one:SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE...
|