Originally created by: jerome.v...@gmail.com
What exact steps will reproduce the problem?
1. Open a connection to the database
2. Choose "Find text on server" in the "Search Menu"
What was the expected output?
- Search Dialog
What happened instead?
- Exception report (attached)
- Messages in the log pane :
SELECT @@SPID;
/* Connected. Thread-ID: 56 */
SELECT DATEDIFF(SECOND, "login_time", CURRENT_TIMESTAMP) FROM "master"."dbo"."sysprocesses" WHERE "spid"=1;
SELECT @@VERSION;
USE "datest";
/* Entering session "Dev-Datest " */
SELECT *, '' AS 'schema' FROM "datest".."sysobjects" WHERE "type" IN ('P', 'U', 'V', 'TR', 'FN');
-- here I select "Find text on server" menu item
SELECT '' AS "Collation", '' AS "Charset", 0 AS "Id", '' AS "Default", '' AS "Compiled", 1 AS "Sortlen";
SELECT "name" AS "Charset", "description" AS "Description" FROM "sys"."syscharsets";
/* SQL Error (208): 'sys.syscharsets' : nom d'objet incorrect. */
on MS SQL 2000 the request should be :
SELECT "name" AS "Charset", "description" AS "Description" FROM master.dbo.syscharsets
Version used?
HeidiSQL revision: [r4453]
OS : Windows 2000
DB : MS sql server 2000
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
This issue was closed by revision [r4456].
Status: Fixed
Related
Commit: [r4456]
View and moderate all "tickets Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Tickets"
Originally posted by: a...@anse.de
[r4456] turns sys.syscharsets to master..syscharsets - works on MSSQL 2008 and should also work on older servers.
Related
Commit: [r4456]