SQL error

Hi

I don't know what causes this bug but am hoping you may be able to suggest a solution or fix it !.

I was browsing the database , lost connection while loading the data from a table , the program freezed so i closed it and re-run it , when I tried to view a table again it says :

SELECT c.name AS "column", prop.value AS "comment" FROM sys.extended_properties AS prop INNER JOIN sys.all_objects o ON prop.major_id = o.object_id INNER JOIN sys.schemas s ON o.schema_id = s.schema_id INNER JOIN sys.columns AS c ON prop.major_id = c.object_id AND prop.minor_id = c.column_id WHERE prop.name='MS_Description' AND s.name='' AND o.name='acctpls'; / Erreur SQL (208) : Invalid object name 'sys.extended_properties' Invalid object name 'sys.columns'. / / Erreur SQL (208) : Invalid object name 'sys.extended_properties' Invalid object name 'sys.columns'. /

it shows this message and keep looping for a few times , and no data is being shown.

Thanks

I used an other program and everything is working fine so its not from the database , I just want to mention that this happened only when the connection got interrupted while reading data from a table , cause it was working fine before.

forgot to mention that I'm conneting to a Microsoft SQL database

None of the tables is shown , here is what i get ( see the attachement )

Will you at least tell me what the problem is ?

I can only guess that we have a version problem again on MSSQL. There are so many critical differences in the MSSQL versions, I cannot work around all of them. On which version are you?

Hi, Using 9.3.0.5056, I have a similar kind of problem when, being connected to a MySQL/MariaDb and viewing the "host"/"processes" tab. Switching to a connection to a MSSQL server : gives an error :

I have attached the MadExcept report :

To avoid this I just select another tab before going from a MySQL to a MSSQL.

Eric