Re: Querying Multiple SQL Servers in one statement
From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 07/29/04
- Previous message: Devin: "Querying Multiple SQL Servers in one statement"
- In reply to: Devin: "Querying Multiple SQL Servers in one statement"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Jul 2004 01:24:20 +0530
you can do this with the help of linked servers using 4 part naming
convention as: linked_server.db.owner.table_name
see more help on following topics and its subtopics in books online.
sp_addlinkedserver
sp_addlinkedsrvlogin
Configuring Linked Servers
-- Vishal Parkar vgparkar@yahoo.co.in | vgparkar@hotmail.com
- Previous message: Devin: "Querying Multiple SQL Servers in one statement"
- In reply to: Devin: "Querying Multiple SQL Servers in one statement"
- Messages sorted by: [ date ] [ thread ]
