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
What is the difference between the 2 operating modes of database mirroring?
How to implement service broker?
What is model database? : SQL Server Architecture
How to create a view with data from multiple tables?
What is use of except clause? How it differs from not in clause?
What are the new scripting capabilities of ssms? : sql server management studio
How to bind a view to the schema of the underlying tables?
User wants only to display only pdf as export option in report manager. How to achieve this?
What are system databases in ms sql server?
Define msdb database?
Explain how dts is used to extract, transform and consolidate data?
Are resultset updatable?
What is open database communication (odbc)?
How do use Having,Group by,Group function in SQL?
What are the benefits of filtered indexes?