is it possible ? stored proc that call stored proc in other SQL server

[Ologhai]

Hi i've question..

is it possible to do this ?

my web application call a [stored proc #1] on [SQL SERVER #1] and this [stored proc #1] call another [stored proc #2] on [SQL SERVER #2].

thank you. --------------------------------
Hugues Gauthier, DEC
Développeur Web

Intelligence Digital
1751 Richardson
Suite 4230
Montréal, Québec
H3K 1G6

http://www.intelligencedgt.com/

hgauthier@intelligencedgt.com
hugues_gauthier@hotmail.com

-------------------
ICQ: 2151800

 

[Ologhai]

Hi me,

DECLARE @retstat int
EXECUTE @retstat = SQLSERVER1.pubs.dbo.checkcontract '409-56-4008'

i found it on msdn..

thank --------------------------------
Hugues Gauthier, DEC
Développeur Web

Intelligence Digital
1751 Richardson
Suite 4230
Montréal, Québec
H3K 1G6

http://www.intelligencedgt.com/

hgauthier@intelligencedgt.com
hugues_gauthier@hotmail.com

-------------------
ICQ: 2151800

 

[MAK9974]

u need to create a linked server on server#1 for server #2

then u can execute a procedure like this.

exec Server2.dbo.db.proc

 

[Ologhai]

Yes and the second server have to be configured for RPC
(remote procedure call.) --------------------------------
Hugues Gauthier, DEC
Développeur Web

Intelligence Digital
1751 Richardson
Suite 4230
Montréal, Québec
H3K 1G6

http://www.intelligencedgt.com/

hgauthier@intelligencedgt.com
hugues_gauthier@hotmail.com

-------------------
ICQ: 2151800