 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
 [9.0.157 BETA] Intellisense on Synonyms |
 |
Hi Team,
Is possible consider improve the SA Intellisense (Columns selection) to include synonyms? :)
|
|
| Thu Oct 06, 2016 2:26 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
It should be already supported. Could you please provide an example of when it doesn't work?
|
|
| Thu Oct 06, 2016 7:45 pm |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Hmm. I imagine it not being able to work properly when remote servers are involved with insufficient permissions for the remote login.
|
|
| Thu Oct 06, 2016 8:03 pm |
|
|
jairo.martinez
Joined: 27 Sep 2016
Posts: 31
Country: Mexico |
|
| |
|
Sorry, until now I've only been using Synonyms, but with REMOTE SQL SERVER (Another IP). I tested with a synonym inside the same SQL instance and works correctly, but not when the table is a remote object.
|
|
| Thu Oct 06, 2016 8:04 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
You are correct. It doesn't work with remote objects. The remote object definitions aren't visible in the local system catalog views which are used for populating the internal cache.
|
|
| Fri Oct 07, 2016 1:27 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
|
|
|
