Tracking database size

• Tad

  Say Hey Kid

  Points: 701

  More actions

  November 1, 2004 at 10:10 am

  #85708

   I would like the data returned from the code below stored in a table.

  This returns two record sets for each db. 

  declare @RETURN_VALUE int

  declare @command1 nvarchar(2000)

  SET @command1 = 'EXEC ?.DBO.SP_SPACEUSED'

  exec @RETURN_VALUE = sp_MSforeachdb @command1 = @command1

  Any ideas ?

• Adam Machanic

  SSCoach

  Points: 15370

  More actions

  November 1, 2004 at 11:27 am

  #528526

  You can't do that as-is; sp_spaceused returns two result sets and is therefore unavailable for the INSERT .. EXEC syntax. Your best bet is probably to re-write sp_spaceused and have it do your inserts for you...

  --
  Adam Machanic
  whoisactive

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 2, 2004 at 12:41 am

  #528564

  This one might proabably be interesting to you:

  http://vyaskn.tripod.com/track_sql_database_file_growth.htm

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]