SP to determine database file growth at intervals

• neiljacobson

  SSCommitted

  Points: 1717

  More actions

  September 23, 2007 at 9:16 pm

  #118345

  Comments posted to this topic are about the item SP to determine database file growth at intervals

• deeptikedar

  SSC Rookie

  Points: 36

  More actions

  October 8, 2010 at 9:28 am

  #1234349

  The script doesnt give me any information. The sysaltfiles table is always empty 🙁

  INSERT INTO [dbo].[tbl_sysaltfiles_1]([fileid], [groupid], , [maxsize], [growth], [status], [perf], [dbid], [name], [filename],[createlsn],[droplsn])

  Select [fileid], [groupid], , [maxsize], [growth], [status], [perf], [dbid], [name], [filename],[createlsn],[droplsn] From master.dbo.sysaltfiles

  The createlsn and droplsn columns do not exist in master.sys.sysaltfiles