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
Answer:
Scenario:
I run a simple query, The connection also Disconnected once the query completed. Why ? and How to fix it ?
Solution:
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.
Asked In: In General
|
Alert Moderator
Found interesting? Add this to: