----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Madhav_S9 Message 7 in Discussion If you wish to find record count for particular table then instead of using Count(*) one can also rely on SYSTEM tables. E.g. following query will return all table name with record counts in a given database Select O.Name, I.rowcnt FROM SYSOBJECTS as O LEFT OUTER JOIN SYSINDEXES as I ON O.id = I.id and i.indid in (0,1) WHERE O.XTYPE = 'U' So you can rewrite your code to something as following. Create Procedure FirstUpdateRecordCount @MonitorTable1 Varchar(100), @MonitorTable2 Varchar(100) INSERT INTO tblRecordCount (tableid,datetimestamp, recordcount) Select O.Name, Cast(GetDate(), varchar(30)), I.rowcnt FROM SYSOBJECTS as O INNER JOIN SYSINDEXES as I ON O.id = I.id and i.indid in (0,1) WHERE O.XTYPE = 'U' AND O.Name IN (@MonitorTable1 , @MonitorTable2) Go Thanks & Regards MadhavRao ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
