Home Forums SQL Server 2008 SQL Server 2008 - General Creating a SQL 2008 synonym to named instance RE: Creating a SQL 2008 synonym to named instance

  • April 22, 2010 at 4:11 pm

    #1156506

    do a select * from sys.servers

    quite often, the alias for your linked server is different than the name of the actual server.

    it's the name of the linkedserver, not the name of the real server, that you need to use to construct the synonym.

    so for example, while the actual server might be named [SQLCLUS3\BIZTALK], i could create the Alias for it as BIZ or MyLinkedServer or whatever i felt was a good mnemonic, so that would be the right portion to use for your synonym.

    [BIZ].[BizTalkMsgboxDb].[dbo].[Tablename]

    [MyLinkedServer].[BizTalkMsgboxDb].[dbo].[Tablename]

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!