Double click .sql file opens new SSMS session

• Edward Shaw

  Ten Centuries

  Points: 1020

  More actions

  May 8, 2019 at 5:51 pm

  #3638478

  When I double click a .sql file, it opens SSMS.  If I double click a second .sql file, it opens a new SSMS session instead of a new tab on the current SSMS session.  We are running v17.8.1

  Is there setting for this.  Have already looked at the following posts and none of this worked:

  https://www.sqlservercentral.com/blogs/opening-sql-files-in-ssms-2016-by-default-sqlnewblogger

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/63a603cc-d970-4434-8f80-309dc9ea688e/sql-files-opening-in-new-ssms-instance?forum=transactsql

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8fed6d0e-813f-4dbc-8add-dbc01ad015c1/how-to-open-multiple-sql-files-in-only-one-ssms-instance?forum=sqltools

  Thanks.

   

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  May 8, 2019 at 7:26 pm

  #3638578

  I've seen this behavior if the already open SSMS program has a modal window or dialog box outstanding, then it can't respond to the operating system's request to open the second file, so a second SSMS program starts up.

• William Dunn

  SSC Veteran

  Points: 298

  More actions

  May 13, 2019 at 5:47 pm

  #3641624

  Is SSMS configured to run as administrator by any chance? Turning this off solved the problem for me after scratching my head for weeks.