>Is there any way in SQL Server to check if a specific server is connected, if not than to connect, but in a automatic way?
>
>TIA
AFAIK, SQL Server do not check if the linked server is connected. That check is done when you execute some query where that server is involved. Also SQL Server does not stay connected to that linked server, it connects, execute query and then disconnects.
But that is only my assumption, no need to be true.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.