Connecting to another SQL Server

Hi,

We are using two databases Live and Contingency. Everyday Backup is
taken and restored the same on Contingency Server. Cotingency Server act
as Live when Live server goes down.

I need to Connect to Contingency Server from Live Server through my
Stored Procedure to Stop/Delete particular Job running on Contingency
Server. Please, can anyone help me in this.


Sun

*** Sent via Developersdex http://www.droptable.com ***

What about set up a Linked Server , from Contingency to LIve ?

--
Jack Vamvas
 ____________________
_______________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Sun G" <sun_x22@yahoo.com> wrote in message
news:5SwUf.6$Ea7.783@news.uswest.net...
> Hi,
>
> We are using two databases Live and Contingency. Everyday Backup is
> taken and restored the same on Contingency Server. Cotingency Server act
> as Live when Live server goes down.
>
> I need to Connect to Contingency Server from Live Server through my
> Stored Procedure to Stop/Delete particular Job running on Contingency
> Server. Please, can anyone help me in this.
>
>
> Sun
>
> *** Sent via Developersdex http://www.droptable.com ***