Linked Server

30 Jun 2005 1:45 PM

Luis Oliveira

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

30 Jun 2005 3:26 PM

Ray

From the server where the linked server item is set up

Try doing a
Select top 10 *
from Linkedserver.DbName.dbo.MyTable

Show quote

"Luis Oliveira" wrote:

> 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
>
>
>

9 Jul 2005 8:45 AM

Tomaz Dezman

Try
SELECT 1 AS A

Show quote

"Luis Oliveira" <luis_mg_olive***@hotmail.com> wrote in message
news:42c3fa44$0$14384$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
>
>