SQL Server connection is terminated after the query completes. Why ?

 Posted by PandianS on 8/26/2010 | Category: Sql Server Interview questions | Views: 4594 | 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.

Asked In: In General | Alert Moderator 

Comments or Responses

Login to post response