June 8, 2007 at 3:29 am
Hi,
Here, i have a question that......
How to check wether the remote sql server services are running or not using local qa.
I am using linked server concept to connect to the remote server....
Any suggestion would be very useful to me.....
Thanks,
Bagath
June 8, 2007 at 3:35 am
sp_addlinkedserver
returns
0 (success) or 1 (failure)
K. Matsumura
June 8, 2007 at 3:43 am
Matsmura,
Can you explain me clearly....?
Thanks,
June 8, 2007 at 3:49 am
sp_addlinkedserver creates linked server.
If successfull it means that server is running.
Falure can be cauesed by many reasons.
Server not running can be the reason.
Please read BOL.
Regards,
K. Matsumura
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply