|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"Record Count of Tables in SQL Server"
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...
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!