• ONe way could be to pipe the result of

    EXEC master.dbo.xp_cmdshell 'osql -L'

    to a table and analyze it thereafter.

    AFAIK, this will work as long as the servers are not hidden, listen on the default port and are running at all.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]