• Brandie Tarvin (7/5/2011)


    GSquared (7/5/2011)


    No, there doesn't appear to be an option for that. The closest would be under Query Execution options, "Disconnect after the query executes".

    Which isn't what I want.

    Darnit.

    Thanks for double-checking.

    Brandie,

    In the File menu in SSMS 2008 R2 there is an option under Open -> File with New Connection and File Disconnected.

    Granted, this does not allow you to double-click to open a file and then login or drag and drop, but it is an option. Unfortunately, there is not a shortcut for this one, but I think that it could be added to the toolbar.

    Regards, Irish