how to tell if a linkedserver is alive

Hello,
I was wondering if it's possible to tell if the connection of a linkedserver
is alive?
I was trying to do something in a linkedserver inside a trigger but I would
like to test if the connection is alive because this action is synscronous.
Imagine that it can't be done and I do something on the linkedserver and
their isn't connection between them can we control the time to timeout and
roolback?
Thanks in advance
Pedro
http://www.sqldbatips.com/displaycode.asp?ID=38
In SQL2005 there is actually a system stored procedure to do this called
sys.sp_testlinkedserver
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Pedro" <Pedro@.discussions.microsoft.com> wrote in message
news:6F72DFCB-71E4-435F-8524-FEFFDA72B535@.microsoft.com...
> Hello,
> I was wondering if it's possible to tell if the connection of a
> linkedserver
> is alive?
> I was trying to do something in a linkedserver inside a trigger but I
> would
> like to test if the connection is alive because this action is
> synscronous.
> Imagine that it can't be done and I do something on the linkedserver and
> their isn't connection between them can we control the time to timeout and
> roolback?
> Thanks in advance
> Pedro