November 28, 2003 at 9:42 am
Hi All, I need your help ... How can I determine the size in Kb of one single table from a DB of SQL Server 2000 ??? I need to know what is the size of a large table to make a decision to drop some records or not. Thanks for your support. Best Regards.
November 28, 2003 at 10:34 am
EXEC sp_spaceused TableName
November 28, 2003 at 1:05 pm
Or set the view is EM to Taskpad
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 30, 2003 at 2:42 pm
How do you set the view in EM to Taskpad ??
Arden
November 30, 2003 at 5:13 pm
To view the taskpad in EM, right click on a database, select view... taskpad.
Cheers,
Kevin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply