exec sp_spaceused [schema.tablename] this will give you data file and the

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 / allah baksh

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

Answer Posted / allah baksh

exec sp_spaceused [schema.tablename] this will give you
data file and the size available

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a functions and types in sql server?

1087

What are the new features of sql server 2012 reporting service?

133

What is difference between getdate and sysdatetime in sql server 2008?

1048

What is 1nf 2nf and 3nf?

891

What are the types of stored procedures in an sql server?

990

query processing

2175

Can a table have 2 primary keys?

983

How do I find the query plan in sql server?

961

Explain acid?

1084

How do I open port 1433?

932

Is null vs coalesce?

885

What is difference between cte and view?

917

What is query processing?

942

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

991

How to handle error or exception in sql?

983