Also use either this one:
SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcnt
FROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.id
WHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'
<br>
or this one:
SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE OBJECTPROPERTY(id,'IsUserTable')=1 AND indid<2
</br>
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
Submit an article or tip
