Synonyms | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Synonyms

Hi all, I have a strange phenom happening. I can create synonyms and utilize them through code. However, when my users (and I tested this as myself too) wish to create views/queries with the synonyms using the designer, the synonyms do not show up under the synonyms tab in the "Add Table" dialog. I have tried everything I can think of for a day and a half now. Can someone lend me a hand??
I see and access the synonym in Desiner window while creating the views…
What Service Pack you are on?
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I just downloaded and installed SP2 and the windows updates that soon followed. A friend of mine says the same thing as you. He has absolutely no problem. It’s a bizarre thing and I really need to figure it out because the group that needs this functionality is our finance department.
quote:Originally posted by ddub I just downloaded and installed SP2 and the windows updates that soon followed. A friend of mine says the same thing as you. He has absolutely no problem. It’s a bizarre thing and I really need to figure it out because the group that needs this functionality is our finance department.

Here’s the actual version info (from management studio):
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
Almost everything is the same on my server…
I can access without any issues.. Did you on the server (local) with SYSADMIN access? MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Yes, I am logged in with the administrator account.<br /><br />I found the issue, which really doesn’t make any sense, but it works. When creating a new synonym, if I enter a server name, it will not display in the GUI tools. However, if I leave the server name blank, it displays just fine. I think I’ll send this one to MS, but only after testing out the theory. [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]
I am able to create a sysnonym when I enter the instance name… You have to give sql server full instance name not server name…
When it is default instance then server name is instance name…
When it is named instance then servernameinstancename is the instance name… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Do you have any DNS or FQDN issues ont he network? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>