Post reply

SQL Server 2008 Query Editor window gets disconnected frequently

  • December 8, 2011 at 4:09 am

    #261084

    I have SQL Server 2008 and SQL Server 2008 R2 Express Edition installed in my machine. I was using SSMS of SQL Server 2008 R2 Express edition to connect to SQL Server 2008 instance in Windows Vista and it was working fine.

    Last week, I upgraded OS to Windows 7. After that, SQL Server 2008 Management Studio Query Editor is getting disconnected automatically when it is idle for sometime. I have to re-connect again in order to run query. What could be the reason? Is there any option to set Query Editor idle time or something?.. Please help..

    Thanks in advance,

    Rekha K Ravi

  • January 3, 2012 at 1:46 am

    #1427577

    Are you facing the issue like completely the the query window goes off or shows the status like not connected in the query window after executing the queries because there is one option in the query window

    if you have enabled it -once the query completed successful then next time when firing the query again it ask for you to connect= >Don't know in your case.

    Option is as mentioned below

    ===================

    Right click on the query window ->Query Options ->Execution : go to Advanced ->there you can see that Disconnect after the query executes.

    Thanks,

    Rama Udaya.K

    ramaudaya.blogspot.com

  • April 2, 2012 at 6:05 pm

    #1467971

    Thanks for the great answer rama38udaya.

    I had to use :

    Tools->Options

    Then:

    Query Execution->Advanced

    Uncheck 'Disconnect after the query executes'

    To get it to remember this option.

    PT.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply