all groups > sql server connect > june 2005 >
You're in the

sql server connect

group:

linked server


linked server Luis Oliveira
6/30/2005 12:00:00 AM
sql server connect: 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

Re: linked server Jens Süßmeyer
6/30/2005 12:00:00 AM
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...
[quoted text, click to view]

AddThis Social Bookmark Button