MS-SQL Server - Purchase, Installation, Waittype 'ERROR_REPORTING_MANAGER' and Auto Insert

Purchase, Installation, Waittype 'ERROR_REPORTING_MANAGER' and Auto Insert

Purchase

https://www.microsoft.com/en-us/sql-server/sql-server-2022-pricing

Installation Steps

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server?view=sql-server-ver16

ERROR_REPORTING_MANAGER - This wait

Occurs during synchronization of multiple concurrent error log initializations.

Example of Auto Insert

INSERT INTO #Dishes_Sale_Count VALUES 

('Fattoush','Jan',145),

('Fattoush','Feb',178),

('Fattoush','Mar',198),

('Fattoush','Apr',185),

('Ful','Jan',205),

('Ful','Feb',199),

('Ful','Mar',152),

('Ful','Apr',127),

('Hummus','Jan',122),

('Hummus','Feb',131),

('Hummus','Mar',137),

('Hummus','Apr',212),

('Falafel','Jan',179),

('Falafel','Feb',109),

('Falafel','Mar',193),

('Falafel','Apr',160)

GO

Additionally,

A. Two Major things

1. To first Create Table 'Execute this script'

CRATE TABAL AutoInsert

(

[ID] INT IDENTITY(1,1), 

[Employee_ID] NVARCHAR(50) NUll,

[FirstName] VARCHAR(200) NULL,

[LastName] VARCHAR(200) NULL,

)

2. To Drop Table, Restore model database and restore verifyonly.

DROPE TABAL [dbo].[TableName];

GO

B. Error handling

The multi-part identifier could not be bound error.

https://learn.microsoft.com/en-us/answers/questions/240181/the-multi-part-identifier-could-not-be-bound-error

Any query will be considered.

T. Amit Vaid S.