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.