April 5, 2006 at 5:10 am
Dear all,
I need to store the size of data file in a table every day to know, how much the size of database growing every day.
If possible I need to know how many rows in each table and how much of the size of table. I also need to store these information to my table on periodic basics.
How it is possible in sql server.
Regards
mathew
April 5, 2006 at 8:09 am
You can write a script using sp_spaceused.
Tom
April 5, 2006 at 8:19 am
Mathew...just as an FYI - if you search the script section on this site you'll find several that do exactly what you want...and here's another post - sp_spaceused tablename for each database for you that also has the script...
**ASCII stupid question, get a stupid ANSI !!!**
April 5, 2006 at 11:10 am
http://www.sqlservercentral.com/columnists/sjones/20010422115754_1.asp
Part 1 deals with users.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply