Name of the command to view the current amount of free (unallocated) space in the database in SQL Server?

Posted by Virendradugar on 11/19/2009 | Category: Sql Server Interview questions | Views: 4891

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Name of command is :sp_spaceused

This command displays the database_size in MB, and it's also shows unallocated space for the database.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the command name to shrink the data file a ...

Next > : What is the name of command in sql server 2005 whi ...

Comments or Responses

More Interview Questions by Virendradugar

What is the name of command in sql server 2005 which is used to kill a ...
How can we find the open transactions details in sql server?
Which system table holds the details of all the processes running on t ...
Which system procedure is used to find out lock details about the data ...
What is the name of the base class, from which all the validators cont ...
Is it possible to use InProc mode for sessionState in case of web gard ...
Is it possible to set SessionState to readonly mode? Readonly mode mea ...
What is the difference between Session.Clear() and Session.RemoveAll() ...

Latest Interview Questions

How to find data with generics list in VB.NET (Write code).
Base class for classes accessing session-state values, session-level s ...
What is difference between TransferRequest and Transfer method?
It is possible to get class or struct indexed just like arrays using…
Which method is used to rewriting/redirecting server-side execution?
Which is the default Provider Name of the Providers used to access the ...
Can we to pass more than one querystring parameter with hyperlink in . ...
DetailsView Control can be displayed in which Modes?
More ...