rajeshjaiswalraj (8/23/2014)
JUST FOR EXAMPLE - i have two SQL server instance A and B.From B i have to check A Instance is up or not. If not it has to send mail
Well, that isn't what you stated above when you were yelling at everyone (you really shouldn't type in all capitals).
Now, how about provide all the details.
To get you started, as I did this years ago at a previous employer, set up a linked server on B to A. Run a simple query across the linked server, say SELECT @@SERVERNAME. If it returns successfully the instance is up, if not then you send an email.