November 18, 2004 at 2:42 pm
HI !
I created one database. I have two file groups in this database. One carried all data (Table and all system info) and second carried all info about indexes. I allocted size 20MB for both group. If i want a see how much space i used and how much i have left with all detial about each object. How can i able to see this info.
Thanks
November 19, 2004 at 8:46 am
Would EXEC sp_helpdb 'your db name goes here' be a start? Or in case when you prefer EM, setting the view option to taskpad?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 22, 2004 at 9:08 am
I tried that. It tell me how much i assiged for each filegroup. I would like to know how much space my filegroup already used and how much i have left in detail.
November 23, 2004 at 12:36 am
sp_spaceused?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply