January 23, 2009 at 12:49 am
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
From BOL:
sp_linkedservers
Returns the list of linked servers defined in the local server.
January 23, 2009 at 6:08 pm
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
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
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