Crash on Trigger - MSSql

[expired user #8992]'s profile image [expired user #8992] posted 9 years ago in General Permalink
Hello!

Browsing a specific database caused a crash trapped my MADEXCEPT.
Report is enclosed...

Kind regards,
Manfred
1 attachment(s):
ansgar's profile image ansgar posted 9 years ago Permalink
So you got the error "Falsche Syntax in der Nähe des FROM-Schlüsselworts."
Which exact query was it?
[expired user #8992]'s profile image [expired user #8992] posted 9 years ago Permalink

So you got the error "Falsche Syntax in der Nähe des FROM-Schlüsselworts."
Which exact query was it?



It was no query at all: I was browsing through the tables of a living MSSQL database and
there are these objects dbo.T1... (Triggers?) which I am sure do not exist in the database.
The moment you click on one of these entries - boum - MADEXCEPT intercepts...
1 attachment(s):
  • crash
ansgar's profile image ansgar posted 9 years ago Permalink
Of course it was a query. Your screenshot shows it:
SHOW TRIGGERS FROM "Z1";
/* SQL error...*/

That's MySQL syntax, not MSSQL, so I wonder why that's executed on your MSSQL server. Which server version is it?
[expired user #8992]'s profile image [expired user #8992] posted 9 years ago Permalink
If you look at the same database with MS SQL Studio you do not find these objects named "dbo.T1...", "dbo.T2...", etc. - they are apparently created by HeidiSQL. The attached screen shot shows MS-view and HeidiSQL-view of the same database at the same time. MS-view does not show any triggers. Server info is attached...
2 attachment(s):
  • no_triggers
  • server_info

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