query to see total database space and used space

[vbbit]

Hi I host my site and sql server database on godaddy, they told me that I have 200MB of Database space. But I am trying to query it using the sql query analyzer to see that total space *200MB*, but I don't know what the query would be? and also the query to see how much space I have used so far?

This is for Sql server 2005

[brucevde]

Execute the sp_spaceused system stored procedure.

[vbbit]

I only see database_size, is that the amount of space that my db is using now? how about the total size that i want to see 200MB

[si_the_geek]

The database system is unlikely to be able to tell you that, as the limit is on the file system and could be done in a variety of different ways) rather than the database.