Naomi,
what I need is to know if a specific SQL Server is linked to another SQL Server, if not link whit sp_addlinkedserver...
not to start-stop the SQL Server.
For some stupid reasons they want to unconnect a linked server conection from a Web server and when some SQL stranasctions occurs re-establish the conection to send some info to the local network server, a after thar disconect the linked server again.

TIA


>Google search brings this http://forums.techarena.in/server-scripting/975633.htm
>
>and just in case
>
>http://www.databasejournal.com/features/mssql/article.php/3644906/Automatically-Stopping-and-Restarting-SQL-Server.htm
>
>Haven't tried them myself.
>
>>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
>>
>>