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?
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
How do you debug a procedure in sql server?
What is the difference between varchar and varchar types?
How to drop an existing stored procedure in ms sql server?
How can you manage sql azure security?
What is snapshot replication?
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?
How to optimize stored procedures in sql server?
What are the instances when triggers are appropriate?
how we use window authentication connection with sql server.?
What do you understand by triggers?
what is an extended stored procedure? : Sql server database administration
System requirements for sql server 2005 express edition?
What are the advantages of using third-party tools?
Are null values the same as that of zero or a blank space?
List out different types of normalizations in sql server and explain each of them?