LIMIT is a MySQL specific command and not available in MSSQL:

[ADarkDividedGem]

http://vorg.ca/626-the-MS-SQL-equivalent-to-MySQLs-limit-command

Looks like you just forgot to remove the MySQL part of the command since you already use the TOP command.