June 19, 2003 at 10:44 am
since sp_addlinkedserver doesn't check the valididty of the remote server I need to check it another way. Does anybody know a way to check a linked server within SQL Server.
jimmY
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
June 19, 2003 at 12:27 pm
What do you need to check? if the server is up, or the agent running?
June 19, 2003 at 12:34 pm
server up and running.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
June 25, 2003 at 5:20 am
How about
xp_cmdshell 'net view \\server_name'
or
xp_cmdshell 'ping server_name'
Direct the output to a file and search for a string in the file
June 25, 2003 at 9:49 am
My Bad, I ment to say need to check for SQL Server up and running, but thanks i to complete that check as well.
So far, I am thinking that using a script is the only way, it seems that SQL Server still believes in the perfect world where servers are always up and everybody has pefect typing. The problem is if the remote server is down the proocedure that you are running will see that as a fatal error and end, no chance on error catching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Work like you don't need the money.
Love like you've never been hurt.
And Dance like no one is watching.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply