Linked Server

Is there a SQL statement that can detect if a linked server exists?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?
>
>|||... 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/
"Mark Williams" <MarkWilliams@.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:
>|||Most excellent!
"Tibor Karaszi" wrote:

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