SQLAgent.out

• handkot

  SSCertifiable

  Points: 5392

  More actions

  September 14, 2011 at 3:23 am

  #1381127

  try this

  create table #t(list varchar(100))

  insert into #t(list)

  exec xp_cmdshell 'dir /-C "c:\Program Files\Microsoft SQL Server\MSSQL\LOG\sqlagent.out"'

  declare @size Int

  Select

  cast(replace(Substring(t.list, 20, Len(t.list) - 20 - 12), ' ', '') As Int)

  From

  #t t

  Where

  CharIndex('sqlagent.out', t.list) > 0

  drop table #t

  I Have Nine Lives You Have One Only
  THINK!