Home Forums SQL Server 7,2000 T-SQL How to quickly obtain number of rows in a table? RE: How to quickly obtain number of rows in a table?

  • thanks David. I thought Raymond only wanted rowcount. The only time that I've found sp_spaceused to not report the number of rows was if someone was in a transaction. Thanks for the update.




    Curtis Smith
    SQL Server DBA
    Well in worked in Theory ...