SQL management studio switching sessions issue RRS feed

  • Question

  • hi,

    i'm facing an issue on SQL server V18.1, which is when opening more than a query session and switching between them, the session ID changes but keeping the displayed query of the first session,

    for example when open 2 queries as below :

    session 1 : select * from table1

    session 2 : drop table table1

    if the active session is 1 and i switched to session 2, the active session comes 2 but the displayed query keeps "Select * from table1", and execute has been clicked, table1 shall be deleted.  

    any suggestions?

    Thursday, August 8, 2019 11:38 AM