Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

link server 1

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Anyone know how to setup link server(s)?
 
Sort by date Sort by votes
Yep.
Run enterprise manager, goto security and add your linked server.
Then you can query it using a four-part name.
i.e.
Select * from linkservername.catalog.schema.object_name

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
620
Volvere
V
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
809
gmmastros
gmmastros
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
391
RobertPhillips
RobertPhillips
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
171
pjw001
pjw001
trisoldee
  • Locked
  • Question
Query multiple DB's on same server for Dynamics GP
Replies
1
Views
162
trisoldee
trisoldee

Part and Inventory Search

Sponsor

Back
Top