C# / .NET Tips
Friday, August 10, 2012
database file usage
SELECT
name
,
size
/
128.0
-
CAST
(
FILEPROPERTY
(
name
,
'SpaceUsed'
)
AS
int
)/
128.0
AS
AvailableSpaceInMB
FROM
sys
.
database_files
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment