linked server

Hi,
anyone knows how to verify if a linked server is active only using SQL code?
This question is because I need to check if a created linked server is ok to
perform actions on it.
Many thanks,
Luis
I always used something like
SELECT 1 FROM LinkedServerName...SomeDummyTable
HTH, Jens SUessmeyer.
"Luis Oliveira" <luis_mg_oliveira@.hotmail.com> schrieb im Newsbeitrag
news:42c42dbf$0$14367$a729d347@.news.telepac.pt...
> Hi,
> anyone knows how to verify if a linked server is active only using SQL
> code?
> This question is because I need to check if a created linked server is ok
> to
> perform actions on it.
> Many thanks,
> Luis
>