Need to know the size of DB

[gracine]

Hi is it possible to query database to know how many diskspace it use on disk ? and what is the physical name of that db ??

thanks

 

[sunila7]

Have a look at sp_spaceused in books online for space used on the machine. Here is a link to it.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_7oqb.asp

About the database name, have a look at db_name()

SELECT db_name()
should give you the result, here is the link to it.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_7oqb.asp

Sunil

 

[gracine]

thanks