help with this syntax

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  August 10, 2008 at 5:13 am

  #124658

  Hi,

  how can i insert into one row the size of the LDF and the MDF from sysfiles,if i have this table and query?

  CREATE TABLE DBSize (DBName sysname, SizeMBTotal int,SizeMDF int,SizeLDF int)

  example = insert DBSize select db_name(), round(sum((/128.0)),2),'SizeOfMDF','SizeOfLDF' from sysfiles

  THX

• Waseem Jaleel

  SSCommitted

  Points: 1706

  More actions

  August 10, 2008 at 7:05 am

  #855748

  insert into DBSize

  select db_name(), round((sum())*8,2) as [SizeMBTotal],

  (select *8 from sysfiles

  where filename like '%.mdf')SizeMDF,

  (select *8 from sysfiles

  where filename like '%.ldf')SizeLDF

  from sysfiles

  Please let me know if this was of help to you. 🙂