Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Linking Two SQL Servers

Re: Linking Two SQL Servers

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Apr 2005 12:41:29 -0700
Message-ID: <1114717289.050440.286200@o13g2000cwo.googlegroups.com>

m.ram..._at_gmail.com wrote:
> Two SQL Servers
> 1) "Test"
> Payroll DB
> Transaction Table
> pr_SubmitTransaction in Payroll DB
> ********************************************
> 2) "Production"
> Payroll DB
> Transaction Table
> Pr_SubmitTransaction in Payroll DB
> Accounts DB
> Pr_VerifyAccounts (@AcctNumber)
> ********************************************
>
> I want to use same pr_VeriftAccounts in both test and production
> Pr_SubmitTransaction stored procedure.
> The pr_SubmitTransaction in production works fine when I say
> Exec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKS
> FINE)
> Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)
>
> Should I use sp_addlinkedServer ?? to do this ?. Please provide me
some
> feedback.
> I know I can acheive this by front end, but I was do it in one stored
> procedure.

Cross-posting is bad in itself... let alone SQL server related post in Oracle NG.

Regards
/Rauf Received on Thu Apr 28 2005 - 14:41:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US