SQL report on DB space used

• tyang

  SSCrazy

  Points: 2231

  More actions

  November 11, 2003 at 9:06 am

  #65153

  If I want to get a report on DB space used, free space, CPU usage etc and set up a job to run automatically. How to write it in T-SQL and stored procedure.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  November 11, 2003 at 3:21 pm

  #481635

  check our script library, there are a few different ones there.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net

• linto

  SSC Eights!

  Points: 851

  More actions

  November 11, 2003 at 8:09 pm

  #481643

  see the link

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_sa-sz_0kro.asp

  Linto