MS SQL Server Connectivity

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

linked server

Luis Oliveira

2005-06-30, 1:23 pm

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

Jens Süßmeyer

2005-06-30, 1:23 pm

I always used something like

SELECT 1 FROM LinkedServerName...SomeDummyTable

HTH, Jens SUessmeyer.

"Luis Oliveira" < luis_mg_oliveira@hot
mail.com> schrieb im Newsbeitrag
news:42c42dbf$0$1436
7$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
>

Sponsored Links