SQL Server Performance Forum – Threads Archive

way to view free file space in SQL 2005 db

Hi all, As much as I resent saying farewell to Taskpad, I can’t find alternative tool to quickly see the FREE SPACE left in the database files.
select * from sysfiles does not provide it. Any clues?

BOL:
To display data and log space information for a database
In Object Explorer, connect to an instance of SQL Server 2005 and then expand that instance. Expand Databases and then click the database to view it. From the toolbar, click View and then click Summary. In the Summary pane, click Report.
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Yes, this is on SQL 2005 Server. But I only using SQL 2005 Management Studio to connect to SQL 2000 server, so Reports are grayed out.

sql_machine, The best way to do this is: SELECT name ,size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 AS AvailableSpaceInMB
FROM SYSFILES
http://www.sqlservercentral.com/col…00tosql2005wherehavealltheoldfeaturesgone.asp I wrote an article sometime ago on the subject, but I think I forgot to include this option in there. Hope this helps.

[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />]Thanks, this is great! <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by BikeBoy sql_machine, The best way to do this is: SELECT name ,size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0 AS AvailableSpaceInMB FROM SYSFILES http://www.sqlservercentral.com/columnists/bBaliner/sql2000tosql2005wherehavealltheoldfeaturesgone.asp</a> I wrote an article sometime ago on the subject, but I think I forgot to include this option in there. Hope this helps. <hr height="1" noshade id="quote"></blockquote id="quote">

]]>