SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Object Browser hangup when synonym name contains Multibyes.

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Object Browser hangup when synonym name contains Multibyes.
Author Message
takakou



Joined: 27 Jan 2009
Posts: 22
Country: Japan

Post Object Browser hangup when synonym name contains Multibyes. Reply with quote
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 View user's profile Send private message Send e-mail
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
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 View user's profile Send private message
takakou



Joined: 27 Jan 2009
Posts: 22
Country: Japan

Post Reply with quote
Hi

I think it's nice.

Thank you.
Mon Jan 29, 2018 3:49 am View user's profile Send private message Send e-mail
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.