SELECT name ,size/128.0 - CAST(FILEPROPERTY (name, 'SpaceUsed')

Syntax to find the used space and free space of the Data
file in a database(SQL Server). Following queries didn't
give the exact Used space and Free Space Information
sp_spaceused;DBCC showfilestats;exec
MyDbName.dbo.sp_spaceused;SP_HELPFILE

Can any one tell me the query for how to find the exact
used data file space and free space in a Data File?

Question Posted / narasimha

2 Answers
7736 Views
Cognizant, I also Faced
E-Mail Answers

Answer Posted / narasimha

SELECT name ,size/128.0 - CAST(FILEPROPERTY
(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is transactional replication?

903

What is the difference between for xml raw and for xml auto?

974

What is report snapshot?

142

What is order of B+tree?

1060

Can one drop a column from a table?

965

What is the difference between Stored Procedures and triggers?

1034

How to convert numeric values to integers in ms sql server?

1007

What is outer join in sql server joins?

1045

What is an active database?

961

Explain in brief how sql server enhances scalability of the database system?

935

What is spatial and temporal data?

931

Tell me what is use of except clause? How it differs from not in clause?

899

How to create a local temporary stored procedure?

946

What is BCP? When does it used in sql server 2012?

998

What is trace flag in sql server?

975