Jobs
Author: Ritik Dodhiwala Date Submitted: 3/9/2007 Category: Database Compatibility: This code has been accessed 6843 times.
Email Yourself this snippet:
No declaration
Code
SELECT TOP 100 PERCENT so.name, si.rowcnt FROM dbo.sysobjects so INNER JOIN dbo.sysindexes si ON so.id = si.id WHERE (so.xtype = 'u') AND (si.indid < 2) AND (so.name <> 'dtproperties') ORDER BY so.name
