Unable to Drag/Drop Queries from Desktop to SQL SERVER Management Studio 2005

  • Hi Folks,

    I am trying to open already saved queries on my machine by dragging and dropping but that's not happening. Its a new machine I am setting up so I am not sure if its something gone wrong in the build order or something else but I do remember that I used to do this .

    Now the only option is to open the query in notepad and then copy it over.

    Much appericiate any advice on this.

    Thanks

  • Hi,

    Found the solution.

    Because SQL Server Management Studio properties changed to run as 'Administrator' it does not like that. Unticked the option and its working fine.

    Thanks

  • This worked for me.  Also resolved an issue where a new instance of SSMS was spawning each time I double clicked a .sql file.

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

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