Geeks With Blogs
Wil Peck Experience is something you don't get until just after you need it.

Recently I was tasked with the responsibility of purging database from one of our SQL 2000 databases.  One of the test cases is to use a copy of a database that is a small production database and delete all of the data contained within.  After the delete is executed then I can review the data tables and see what is left over or was skipped after the delete script runs.  Looking at the properties of hundreds of tables in Enterprise Manager seemed pretty tedious. 

After a quick query to Bing I was able to find a decent reference where someone had already done the work for me. 

 

http://sqlserver2000.databases.aspfaq.com/how-do-i-get-a-list-of-sql-server-tables-and-their-row-counts.html

Technorati Tags: ,
Posted on Monday, August 2, 2010 4:18 PM | Back to top

Comments have been closed on this topic.
Copyright © Wil Peck | Powered by: GeeksWithBlogs.net | Join free