SQL Server connection is terminated after the query completes. Why ?
Interview question and answer by: PandianS
| Posted on: 8/26/2010 | Category: SQL Server Interview questions
| Views: 2069 | | Points: 40
I run a simple query, The connection also Disconnected once the query completed. Why ? and How to fix it ?
Query Menu --> Query Options... --> Select Advanced node under the Execution root node.
Un-Select the check box "Disconnect after the query executes" and Click OK.
| Alert Moderator
Found interesting? Add this to: