In response to:

-- Query analyser SQL2000

Server: Msg 102, Level 15, State 1, Line 5

Incorrect syntax near 'go'.

Hi,

you are right, this technique does not works in SQL 2000. Its works version SQL 2005 and above and same statement works in sqlcmd without any error. It repeats the batch no of times as integer value mentioned after GO statement.