Hi Micael,

I need to automate the process to Excel sheet.. is there any way to do
that. and more over i only need to get row counts for specific tables only
not all.. please help.

Regards,
Sree.




"Michael Finley"
<[Email Address Removed] To: "LazyDBA.com Discussion"
tions.com> <[Email Address Removed]
cc:
10/22/2003 10:29 AM Subject: RE: Record Counts for all Tables






Sree,

Use the attached stored proc to generate the number of recs and size and
paste into Excel. Once in excel, you can easily transform from the
columns to rows by copying the cells then using the "Paste Special" -
Transpose option.

Good luck,

Mike

http://www.SQLScriptSafe.com
Tool that Integrates VSS and SQL Server




-----Original Message-----
From: [Email Address Removed] Tuesday, October 21, 2003 8:56 PM
To: LazyDBA.com Discussion
Subject: Record Counts for all Tables

Friends,
need help again

I've some tables where i need to get all the Record counts of Specified
tables (or Sql Queries) and transfer them to an excel sheets like this..

tables

====================================================
table1 table2 table3 table4
====================================================
40 Recors 20 Records 38 Records 23 Records,
====================================================


Regards,
Sree.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] attached file: spGetTableRowCountAndSize.txt)
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page