SQLTeam.com | Weblogs | Forums

Is there a way to Disconnect Linked Server connection - Not delete and re-add


#1

I have created a linked server to ODBC Data source.

It works well. When I query SQL Server Linked server sends connect odbc call and executes the queries.
If I wait for 1 minutes with no activity the connection is closed automatically.

Is there a way to Disconnect Linked Server connection - Not delete and re-add. I would like to do similar to what we do in any programming language i.e

cn.Disconnect() - To send the disconnect command to the DNS data source.