Ms SQL 2000 support

matrik posted 5 years ago in General
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?
richard posted 5 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)
ansgar posted 5 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.

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