I'm upgrading from v2.6 to v4.0 and see, that the runtime queries generated for SQL Server 2000 (v8.0.2039 = SQL 2000) with a 'TOP'-clause are wrong. The transact-sql syntax is 'SELECT DISTINCT TOP x' and not 'SELECT DISTINCT TOP(x)', as is generated (this is the syntax for SQL 2005 and up ) by LLBLGen.

As a result, i'm getting "Incorrect syntax near '('. " at runtime.

Extra info:

i'm using LLBLGen V4.0 June 18th, 2013 version.

I've also just installed a debug-dll from thread http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=22092

Just set the compatibility-level to SQL2000.

Thanks, that solved the problem. Should've found it in the documentation... my mistake.

It's an easy mistake to make when you're migrating from v2 to v4, as the default in v2 was sqlserver 2000 and in v4 it's sqlserver 2005+