Syntax Error on Export from SQL Server 2005

10 posts
[expired user #6764]'s profile image [expired user #6764] posted 11 years ago in Import/Export Permalink
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, '') */;
10151 posts
ansgar's profile image ansgar posted 11 years ago Permalink
Please update to the latest build, I think I had fixed that some time ago. Or is it already the latest build?
10 posts
[expired user #6764]'s profile image [expired user #6764] posted 11 years ago Permalink
Anse, hi yes it is the latest version 7.0.0.4312
Code modification/commit from ansgar.becker, 11 years ago, revision 7.0.0.4313
Quote db and table name in new function TDBObject.QuotedDbAndTableName, which also adds "dbo" for MS SQL inbetween. Plus, run SELECT in SQL export through ApplyLimitClause, to fix an SQL error on MS SQL. See http://www.heidisql.com/forum.php?t=11956
10151 posts
ansgar's profile image ansgar posted 11 years ago Permalink
Should be fixed in r4313
10 posts
[expired user #6764]'s profile image [expired user #6764] posted 11 years ago Permalink
yes that looks like it has done the trick many thanks

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