Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-20 : 09:53:15
|
| John writes "Hi,I used to work with a guy when I was contracting at MSN and he turned me on to a system stored procedure that would return the number of rows for a table along with other information but I cannot find it now. Funny I remember his name but not the name of the sproc.Was this all just a vivid halucination or does such a stored procedure exist or did it ever? I remember that it was much more efficient than doing some thing like this "Select count(*) from table_name".Please help me restore sanity to my world.Thank you,John" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-04-20 : 09:53:15
|
| We've got a script on the site called bigtables.sql. With a little (very little) modification that should do what you want. |
 |
|
|
|
|
|
System stored procedure that returns rowcount for table