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

  • Shazme

    Ten Centuries

    Points: 1292

    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

  • Shazme

    Ten Centuries

    Points: 1292

    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

  • sam bryant

    Right there with Babe

    Points: 726

    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 3 (of 3 total)

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