MSSQL Schemas - v9.1.0.4867

[expired user #8782]'s profile image [expired user #8782] posted 9 years ago in General Permalink
I'm using version 9.1.0.4867 against SQL Server 2012 and 2008 R2. When connecting to either of these the tables read fine, but the schemas they are in are ignored.

This leads selecting a table and clicking "Data" to report "SQL Error (208): Invalid object name 'DataBaseName..TableName'. The full reference to a table should be 'DataBaseName.SchemaName.TableName'.

I searched for this issue and found many references to it in relation to HeidiSQL at code.google.com, but those links are dead. Is there a way to get HeidiSQL to read the schema names when connecting?
[expired user #8782]'s profile image [expired user #8782] posted 9 years ago Permalink
Well, never mind. I found it almost immediately after giving up and posting. Changing the TreeStyleOptions to "group by type" also includes the schemas.
[expired user #8818]'s profile image [expired user #8818] posted 9 years ago Permalink
I searched for this issue and found many references to it in relation to HeidiSQL at code.google.com, but those links are dead. Is there a way to get HeidiSQL to read the schema names when connecting?

aliiii
ansgar's profile image ansgar posted 9 years ago Permalink
Is that spam or what is that, waleed030 ? Your reply does not seem to be related to the above questions.

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