Space for sql in disk ?

• Felipe Venancio

  Mr or Mrs. 500

  Points: 539

  More actions

  July 2, 2004 at 7:12 am

  #164210

  Does somenone knows, how can i see how much space i have queries?

  I want to execute a query that shows how much space i have in disk.

   

  Regards,

  Felipe

• Max-146500

  SSCarpal Tunnel

  Points: 4691

  More actions

  July 2, 2004 at 7:31 am

  #513150

  There's quite a good column just released dealing with this:

  http://www.sqlservercentral.com/columnists/mnash/monitoringdriveanddatabasefreespace.asp

  Just copy out the script Step 1 to 4 and then SELECT * FROM DrvSpace

  Max

  Max

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  July 2, 2004 at 7:44 am

  #513160

  you can try master.dbo.xp_fixeddrives