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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Calculation of table size in SQL En.Man 8.0

Author  Topic 

Georgio
Starting Member

6 Posts

Posted - 2005-10-25 : 12:43:13
Please help me..
I use the Microsoft SQL Enterprise Manager 8.0 and i want to see the size of mbytes in one Table or a row.
This version of Microsoft SQL Enterprise Manager does not have the option of TABLE INFO like the older version 7.0.
Is there any way to see this in that version???
Command line maby???
I really need help

Thanks Georgio

nr
SQLTeam MVY

12543 Posts

Posted - 2005-10-25 : 13:18:27
Try sp_spaceused in query analyser

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Georgio
Starting Member

6 Posts

Posted - 2005-10-25 : 14:47:16
Thanks my friend... You saved my life :)
Go to Top of Page
   

- Advertisement -