"Derek Hart" wrote:

> Is there a SQL statement that can detect if a linked server exists?
>
>
>

"Mark Williams" <MarkWilli***@discussions.microsoft.com> wrote in message
news:D97EAED7-F0C4-4956-BE52-576FE29AC5EF@microsoft.com...
> You can query the sysservers system table in SQL 2000, or the sys.servers
> system view in SQL 2005.
> --
>
>
> "Derek Hart" wrote:
>
>> Is there a SQL statement that can detect if a linked server exists?
>>
>>
>>

"Tibor Karaszi" wrote:

> .... and if the definition exists and you want to see "if it is there", you can use the new
> sp_testlinkedserver
>  in 2005.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>