How to query two SQL Server instances

From: Alan (NOSPAMalan_pltse_at_yahoo.com.au)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 16:05:08 +1000

I need to run a stored procedure, or make it simpler, to run a query to
access the databases from two machines location at different locations.

On client's machine A, say in city A, have installed SQL Server, another
machine in head office, say in city B, there is another SQL Server in that
machine.
I need to execute a query/stored procedure to query the local database(city
A) and the database in head office(city B), what configuration of the local
machine SQL Server should need to do in order the stored procedure can 'see'
the databases in head office ?

Do I need to register the head office SQL Server instance in EM of the local
SQL Server ? Then need to make it as linked server ?

Please help, thanks in advance.

Relevant Pages

  • Re: Stored procedure
    ... the stored procedure. ... to use in ISAM databases (yes... ... fields are not used in SQL Server except in rare situations. ... > @Param3 money, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Stored procedure
    ... Thanks Nick, I actually did create them in the sql server, I just didn't how ... > the stored procedure. ... > to use in ISAM databases (yes... ... >> @Param3 money, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Same transaction on 2 different DB
    ... databases. ... Pro SQL Server 2000 Database Design - ... > tran, select insert and update some table from both the DB, this ... > has effects on both DB or only in the DB in which the stored procedure is? ...
    (microsoft.public.sqlserver.programming)
  • Re: How to query two SQL Server instances
    ... SQL Server Programmer ... > I need to run a stored procedure, or make it simpler, to run a query to ... > the databases in head office? ... Then need to make it as linked server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Mirroring a DB to multiple servers
    ... We are currently running SQL server 2005 on two servers. ... SQL Mirroring to mirror the databases in the head office to the SQL server ...
    (microsoft.public.sqlserver.setup)