Database SIZE

Hola ,

wrote:

hi,I always got space issues on my drives.I wants to know that how much
is the size of a database and how much space we have with in Database
(Both log and Mdf files) and how much it gonna be shrinked after
shriniking it.

Puedes usar el procedimiento almacenado sp_spaceused.

USE AdventureWorks;
GO
EXEC sp_spaceused @updateusage = N'TRUE';
GO


Gustavo Larriera, MVP
Solid Quality
MVP profile: http://aspnet2.com/mvp.ashx?GustavoLarriera
Blog: http://solidqualitylearning.com/blogs/glarriera/
Este mensaje se proporciona tal como es, sin garantías de ninguna clase
/ This message is provided "AS IS" with no warranties expressed or
implied, and confers no rights.