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
7767 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

How do you debug a procedure in sql server?

907

What is the difference between varchar and varchar types?

1015

How to drop an existing stored procedure in ms sql server?

983

How can you manage sql azure security?

101

What is snapshot replication?

1011

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

979

How to optimize stored procedures in sql server?

1133

What are the instances when triggers are appropriate?

942

how we use window authentication connection with sql server.?

1101

What do you understand by triggers?

872

what is an extended stored procedure? : Sql server database administration

1009

System requirements for sql server 2005 express edition?

960

What are the advantages of using third-party tools?

933

Are null values the same as that of zero or a blank space?

998

List out different types of normalizations in sql server and explain each of them?

899