| 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: 7963
|
|
| |
|
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: 2170
|
|
| |
|
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: 7963
|
|
| |
|
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 |
|
|
|
