Checking database size and space available without Enterprise Manager

[logicalunatic]

I'm looking for an SQL statement that will return the size and space available of one of my databases.

I've looked in the sysfiles & sysfiles1 tables but the numbers don't seem to add up.

Thanks in advance.

 

[SQLBill]

Have you checked out the procedure "sp_spaceused"???

-SQLBill

Posting advice: FAQ481-4875