distal-attribute
distal-attribute
distal-attribute
distal-attribute

Syntax Error on Export from SQL Server 2005

User, date Message
Written by finbarMoney, Euro
2 years ago
Category: Import/Export
7 posts since Thu, 17 Jan 13
I am trying to export a single table from SQL Server Express 2005
but it show an error the log message is below.

It doesn't matter what the table is same error

SELECT * FROM "SCANP"."st_trn_comp88" LIMIT 0, 104857600;
/* SQL Error (102): Incorrect syntax near '0'. */
/*!40101 SET SQL_MODE=IFNULL(@OLD_LOCAL_SQL_MODE, '') */;
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Please update to the latest build, I think I had fixed that some time ago. Or is it already the latest build?
Written by finbarMoney, Euro
2 years ago
7 posts since Thu, 17 Jan 13
Anse, hi yes it is the latest version 7.0.0.4312
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
Should be fixed in r4313
Written by finbarMoney, Euro
2 years ago
7 posts since Thu, 17 Jan 13
yes that looks like it has done the trick many thanks
 

Please login to leave a reply, or register at first.