Wednesday, December 31, 2014

Automation of Sql Server error log

Similar:




CREATE TABLE [dbo].[ERRLOG](
[LogDate] [datetime] NULL,
[ProcessInfo] [varchar](50) NULL,
[Text] [varchar](MAX) NULL
) ON [PRIMARY]

insert into errlog exec [sp_readerrorlog] 0
insert into errlog exec [sp_readerrorlog] 1
insert into errlog exec [sp_readerrorlog] 2





¯\_(ツ)_/¯



No comments:

Post a Comment