Post reply

Linked Servers

  • December 14, 2006 at 8:38 am

    #98022

    Hi,i need help with linked servers.

    What is the best way to check if linked server is active?

  • December 14, 2006 at 9:07 am

    #678115

    Run sp_helpserver

     

  • December 14, 2006 at 9:21 am

    #678122

    sorry, maybe I wasn't clear in my question,

    I now how to find if there is a definition of linked server,

    just don't now what is the best way to find if that linked server works

  • December 14, 2006 at 9:26 am

    #678125

    I think you'll have to do some pooling at a specific interval.  And run a query like :

    Select top 1 null FROM LinkSrver.master.dbo.SysObjects

  • December 14, 2006 at 9:34 am

    #678128

    I tryed something like that, bat it was working to loong

    In my case there are 8 linked servers and if only one is not working waiting time is 15-25s.

    (if the number of not-working servers goes up... )

    I read that on 2005 there is sp_testLinkedServer function, but my server iz 2000

  • December 14, 2006 at 9:49 am

    #678133

    Have you looked at the code of the system proc to see if it could be adapted to 2000?

  • December 15, 2006 at 6:47 am

    #678312

    My linked servers are not SQL Servers, but a Progress database. In my DTS programs, the first step is to issue a basic statement

    select * from openquery(linkedserver, 'select count(*) from empty_table')

    against an empty, unused table in the linked server's database. Then a workflow step determines whether to continue (if connection was successful) or to send an email alert to me (if the connection was unsuccessful).


    smv929

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply