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.