Re: How to query two SQL Server instances

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roji. P. Thomas (lazydragon_at_nowhere.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 11:47:28 +0530

Just make it as linked server 

-- 
Roji. P. Thomas
SQL Server Programmer
"Alan" <NOSPAMalan_pltse@yahoo.com.au> wrote in message
news:ePcCQFbWEHA.1764@TK2MSFTNGP10.phx.gbl...
> 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: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)