Comments on: Create linked server from sql 2000 to sql 2005http://itknowledgeexchange.techtarget.com/itanswers/create-linked-server-from-sql-2000-to-sql-2005/
Mon, 19 Mar 2018 13:35:41 +0000hourly1By: rechilhttp://itknowledgeexchange.techtarget.com/itanswers/create-linked-server-from-sql-2000-to-sql-2005/#comment-89948
Fri, 25 Mar 2011 09:36:47 +0000#comment-89948Identify the linked server as an instance of Microsoft SQL Server. If u use this to defining…. the name specified in Linked server must be the network name of the server. Also, any tables retrieved from the server are from the default database defined for the login
on the linked server.
It can be done by providing grant (T-SQL statements) to the same user/login name and create a linked server from SQL Server 2005 instance to SQL Server 2000 instance by running SSMS !
]]>