I am trying to figure out why I can't insert in a batch on a specific server. For example, on the Universal Thread, I can do something like this:
INSERT INTO Search (AddUser,NoThread) VALUES (1,1502575), (1,1502572), (1,1502569), (1,1502568)
This will insert four records into Search from one command.
But, on another server, I am doing something very simple:
INSERT INTO HitReportActivity (NoEntity) VALUES (1), (1)
And, I get:
"Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','."
Is there a setting that enables that support? Or, is it that SQL Server 2005 doesn't support it.