Troubleshooting - How to close SQL Linked Server connection

Problem Description:

We are using QRemote with SQL Linked Servers with several different QuickBooks files. How can we close the connection to a QuickBooks file after the query has run, then open it to connect to another database?  

Solution:

SQL Server Linked Server automatically handles disconnect.

SQL Server Linked Server does not have a disconnection command which can be fired/executed.

After executing the query, you will have to wait 30-45 seconds. SQL Server will automatically send the disconnect command if there is no activity on the linked server connection.