• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

link 2 sql 2005 servers

I have a sql 2005 server and I have another sql 2005 server that my program wants me to link together how woudl i do this?
0
zenworksb
Asked:
zenworksb
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
create a linked server b/w these and use the Fully Qualified name ( servername.databaseName.ObjectOwner.TableName ) instead of just table names
0
 
zenworksbAuthor Commented:
can you provide the steps in accomplishing this?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
TAB8Commented:
Also If your are testing this ......
With Windows 2003 server and Linked servers you need to adjust the following ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql 
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now