xp_readerrorlog 수집

msdtc 없이 사용하는 방법


declare @sql varchar(8000)
, @start_dt varchar(8000)
, @end_dt varchar(8000)
, @linkedserverName varchar(8000)

select @sql =''
, @start_dt = '2011-05-11'
, @end_dt = '2011-05-13'
, @linkedserverName = 'linkedservername'

set @sql = '
insert into tblx
select * from openquery ('+@linkedServerName+',
''
set nocount on
set transaction isolation level read uncommitted
declare @tblx table
(a datetime
,b varchar(100)
,c varchar(7000)
)
insert into @tblx
exec xp_readerrorlog 0, 1, '''''''', '''''''','''''+@start_dt+''''','''''+@end_dt+'''''
select * from @tblx
'')
'

exec (@sql)