| Author: www.DotNetVJ.com 30 Jun 2008 | Member Level: Diamond | Rating:  Points: 6 |
Hi
SQL Server has a handy little system stored procedure named sp_spaceused that will return the space used by a database or by a particular table. To determine the size used by the database, simply run:
EXEC sp_spaceused
This will return two result sets, the first one containing the database name, size, and unallocated space and the second containing a breakdown of the database's size into how much size is reserved and how much of that is taken up by data, how much by indexes, and how much remains unused.
Check out the below link for more information
http://www.4guysfromrolla.com/webtech/032906-1.shtml
Thanks -- Vj
http://dotnetvj.blogspot.com
Thanks -- Vijaya Kadiyala
http://www.DotNetVJ.com
Microsoft MVP
Me & My Little Techie
|
| Author: Sandesh S 30 Jun 2008 | Member Level: Gold | Rating: Points: 2 |
Hi,
go to the properties of the database in Emterprisemanager to get the DB size. please check the attachment
Regards,
Sandesh Segu
http://sanssql.blogspot.com
http://www.orkut.co.in/Main#Community?cmm=96088888
SansSQL
 |
| Author: Bunty 01 Jul 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
You can use the system defined stored procedure to calculate the size of the database.
EXEC sp_spaceused
Execute the above query and you will get the desired ouput.
Thanks and Regards
S.S.Bajoria
Thanks & Regards
S.S.Bajoria
|
| Author: Sriram 01 Jul 2008 | Member Level: Gold | Rating: Points: 0 |
exec sp_spaceused
|