>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.

SQL Server 2005 does not support this syntax. It's SQL 2008 new syntax.