I just don’t understand....

From

CREATE TABLE [dbo].[ErrLogData](

[LogID] [int] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NULL,

[ProcessInfo] [nvarchar](50) NULL,

[LogText] [nvarchar](4000) NULL,

[SQLServerName] [nvarchar](150) NULL,

PRIMARY KEY CLUSTERED

(

[LogID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET STATISTICS IO ON

GO

-- Remove older data

IF EXISTS (SELECT * FROM [ErrorLogStorage].[dbo].[ErrLogData])

BEGIN

TRUNCATE TABLE [ErrorLogStorage].[dbo].[ErrLogData]

END

DECLARE @SQLCmd VARCHAR(1024)

SELECT @SQLCmd = 'Insert Into [ErrorLogStorage].dbo.ErrLogData (LogDate, ProcessInfo, LogText) Exec master..xp_readerrorlog'

EXEC (@SQLCmd)

-- Cycle through the ErrLogData table and insert the server''s name

DECLARE SrvName_Cursor CURSOR FOR

SELECT [SQLServerName] FROM [ErrorLogStorage].[dbo].[ErrLogData] WHERE [SQLServerName] IS NULL

OPEN SrvName_Cursor

FETCH NEXT FROM SrvName_Cursor

WHILE @@FETCH_STATUS = 0

BEGIN

UPDATE [ErrorLogStorage].[dbo].[ErrLogData] SET [SQLServerName] = @@servername

FETCH NEXT FROM SrvName_Cursor

END

CLOSE SrvName_Cursor

DEALLOCATE SrvName_Cursor

GO

SET STATISTICS IO OFF

GO

Table 'ErrLogData'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 0, logical reads 225, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'Worktable'. Scan count 1, logical reads 232, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'Worktable'. Scan count 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 1, logical reads 32, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 1, logical reads 9, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

To

SET STATISTICS IO ON

GO

-- Remove older data

IF EXISTS (SELECT * FROM [ErrorLogStorage].[dbo].[ErrLogData])

BEGIN

TRUNCATE TABLE [ErrorLogStorage].[dbo].[ErrLogData]

END

INSERT

INTO [ErrorLogStorage].dbo.ErrLogData

(

LogDate

,ProcessInfo

,LogText

)

EXEC master.dbo.xp_readerrorlog

UPDATE [ErrorLogStorage].[dbo].[ErrLogData]

SET [SQLServerName] = @@SERVERNAME

SET STATISTICS IO OFF

GO

Table 'ErrLogData'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 0, logical reads 225, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'Worktable'. Scan count 1, logical reads 232, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 1, logical reads 32, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Or

CREATE TABLE [dbo].[ErrLogData](

[LogID] [int] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NULL,

[ProcessInfo] [nvarchar](50) NULL,

[LogText] [nvarchar](4000) NULL,

[SQLServerName] [nvarchar](150) DEFAULT(@@SERVERNAME) NOT NULL,

PRIMARY KEY CLUSTERED

(

[LogID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET STATISTICS IO ON

GO

-- Remove older data

IF EXISTS (SELECT * FROM [ErrorLogStorage].[dbo].[ErrLogData])

BEGIN

TRUNCATE TABLE [ErrorLogStorage].[dbo].[ErrLogData]

END

INSERT

INTO [ErrorLogStorage].dbo.ErrLogData

(

LogDate

,ProcessInfo

,LogText

)

EXEC master.dbo.xp_readerrorlog

SET STATISTICS IO OFF

GO

Table 'ErrLogData'. Scan count 1, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'ErrLogData'. Scan count 0, logical reads 225, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Table 'Worktable'. Scan count 1, logical reads 232, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

?