Ms SQL 2000 support

1 posts

[expired user #6473] posted 12 years ago in General

Hi!
I'm using HeidiSQL for connection to MS SQL 2000 Server.
When I'm editing datas in SQL-query program generate sql-update query with TOP command
For example:
UPDATE TOP(1) "Blabla" SET blabla ...
Unfortunately TOP command is not supported in MS SQL 2000 Server.
If I manualy delete word TOP from updating query all works perfectly.
Is it possible to add option for MS SQL server 2000, which allows to remove TOP from UPDATE command?
Thank.

8 posts

[expired user #81] posted 11 years ago

We have the same Problem, so HeidiSQL ist not useable for SQL Server 2000.

SELECT @@Version
---------------------------------

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

10137 posts

ansgar posted 11 years ago

Could you please update your HeidiSQL to the latest build? I'm not sure but I think I had fixed that some time ago. This thread is old.