Post reply

How to check remote ms sql server services using local qa?

  • June 8, 2007 at 3:29 am

    #176984

    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

    #711610

    sp_addlinkedserver

    returns

    0 (success) or 1 (failure)

    K. Matsumura

  • June 8, 2007 at 3:43 am

    #711611

    Matsmura,

       Can you explain me clearly....?

     

    Thanks,

  • June 8, 2007 at 3:49 am

    #711612

    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