Ms SQL 2000 support

User, date Message
Written by matrik
2 years ago
Category: General
1 posts since Thu, 05 Jul 12
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?
Written by richard
2 years ago
7 posts since Tue, 15 Aug 06
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)
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
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.