----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 5 in Discussion The simplest method is to use the COUNT(*) function as shown by Kalpesh. You can also use the DBCC SHOW_STATISTICS command to get the number of rows in the table (without actually hitting the table itself). For this method to be accurate, you statistics on the indexes should be upto date. HTH, Srinivas Sampath MVP - SQL Server http://www32.brinkster.com/srisamp ----------------------------------------------------------- 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]
