 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
takakou
Joined: 27 Jan 2009 Posts: 22 Country: Japan |
|
Object Browser hangup when synonym name contains Multibyes. |
|
Database SQL server 2016
SQL Assistant Version 9.5.449 Pro
Database X contains synonym MS_科目
(科目 means accounts.)
Synonym MS_科目 refers Link server table LS_Y.Y.dbo.科目.
When current database is master, Object Browser is correct.
But current database is X, Object Browser hangup when X.dbo is clicked.
I think Synonym object memory cash may be incorrect....
Thank you.
|
|
Fri Jan 26, 2018 2:10 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you for reporting this. There might be an issue with the synonyms for remote tables. I do not think we support that yet. The SQL Assistant internally tries to expand the synonym in order to retrieve table and column definition for the referenced object, and it expects the table to be local to the server (3 part name or something like that).
I'm going to submit a new ticket to have the DB Explorer ignore remote tables and don't try to expand their synonyms.
|
|
Fri Jan 26, 2018 11:53 am |
|
 |
takakou
Joined: 27 Jan 2009 Posts: 22 Country: Japan |
|
|
|
Hi
I think it's nice.
Thank you.
|
|
Mon Jan 29, 2018 3:49 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|