Post reply

Linked servers

  • January 23, 2009 at 12:49 am

    #129649

    Hi guys..

    I am in the process of migrating sql server 7.0 to sql server 2005..I have migrated all the objects of a given database into sql 2005 except linked servers, as there are other databases on the 7.0 server that might be using those linked servers..Now i want to create external linked servers associated with that database in 7.0 on sql 2005..Can some one help me how to find linked servers that are to be created on 2005..

  • January 23, 2009 at 10:24 am

    #931943

    From BOL:

    sp_linkedservers

    Returns the list of linked servers defined in the local server.

  • January 23, 2009 at 6:08 pm

    #932113

    Through the GUI (i.e. SSMS, Enterprise Manager)...

    2005 - Linked Servers are listed under Server Objects within Object Explorer

    2000 - Linked Servers listed under Security

  • January 24, 2009 at 6:07 am

    #932201

    sun256 (1/23/2009)

    Hi guys..

    I am in the process of migrating sql server 7.0 to sql server 2005..I have migrated all the objects of a given database into sql 2005 except linked servers, as there are other databases on the 7.0 server that might be using those linked servers..Now i want to create external linked servers associated with that database in 7.0 on sql 2005..Can some one help me how to find linked servers that are to be created on 2005..

    The only way I know of that you can do this is by scripting out all your code (sprocs, UDFS, views etc.) in the particular db, and searching for each of the linked server names in the code. Whichever ones appear there are the ones you need to migrate to the sql 2005 instance. You will need to do the same for each of your other dbs (in the sql 7 instance), to ensure you keep all linked servers in the sql-7 that are needed. Some of the linked servers may be used by more than one dbs.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • January 24, 2009 at 11:41 am

    #932252

    If you need to identify script that comprises link server name you need only to call sys.syscomments where text like '%linksrv_name%'

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply