Re: Using Multiple database

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 05/10/04


Date: Mon, 10 May 2004 23:13:48 +0530

you will have to take help of linked servers. See more info on creating
linked server in books online. You will have to make use of 4 part naming
convention in that case.

-- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com
"SAMAY" <anonymous@discussions.microsoft.com> wrote in message
news:7EBE1D7E-C9B4-4AD2-BF71-E3C42F291CB2@microsoft.com...
> What if I have the tables in  different server
>
>
> Thanks......


Relevant Pages

  • Re: Linked server
    ... Does the information in Books Online ("Configuring Linked Servers" has ... a diagram of the architecure) not give you enough information? ...
    (comp.databases.ms-sqlserver)
  • Re: link sql servers using enterprise manage
    ... > manager. ... Check the "Configuring Linked Servers" topic in Books OnLine ...
    (microsoft.public.sqlserver.security)
  • Re: Querying Multiple SQL Servers in one statement
    ... 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. ... Configuring Linked Servers ...
    (microsoft.public.sqlserver.mseq)