InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 14:53:36 GMT20http://www.sqlservercentral.com/Forums/Topic481852-146-1.aspxKeep in mind those reports are only available if Service Pack 2 is installed. Tue, 08 Apr 2008 19:19:35 GMTTodd Engenhttp://www.sqlservercentral.com/Forums/Topic481852-146-1.aspx[quote][b]Todd Engen (4/8/2008)[/b][hr]Here's one simple way to do that. Just copy-and-paste the results into another query window.[code]USE MyDatabaseSELECT 'SELECT COUNT(*), ''' + name + ''' FROM ' + name FROM sys.tables[/code]Or you could look at using the stored procedure sp_MSforeachtable.[/quote]Or - right-click on the database, Reports, Standard Reports, Disk Usage by Table (it also includes the record counts and then some).Tue, 08 Apr 2008 14:11:16 GMTMatt Miller (#4)http://www.sqlservercentral.com/Forums/Topic481852-146-1.aspxHere's one simple way to do that. Just copy-and-paste the results into another query window.[code]USE MyDatabaseSELECT 'SELECT COUNT(*), ''' + name + ''' FROM ' + name FROM sys.tables[/code]Or you could look at using the stored procedure sp_MSforeachtable.Tue, 08 Apr 2008 14:06:37 GMTTodd Engenhttp://www.sqlservercentral.com/Forums/Topic481852-146-1.aspxHi All,I have xyz database which is containing 100 user table. Is there any script which I can use to get total number of records in user table seperatly.Urgent help would be appreciable.Regards,AustinTue, 08 Apr 2008 13:41:15 GMTAustin_123