SSMS - Re-open queries after a reboot?

  • Hi,

    Is there a setting somewhere in SSMS (Sql 2012) that will reopen query tabs after a

    reboot? I know that I can browse to the temp folder and open them myself, however

    it would be good to know if SSMS can just reopen them like Chrome or Firefox

    does with tabs.

    Thanks in advance

  • Actually if they are not saved I find that SSMS does tend to prompt you if you want to open previously opened Query Editor windows. You get a window with the file names and whether or not you want to open them. This is if SSMS is closed unexpectedly though.

    Joie Andrew
    "Since 1982"

  • Joie Andrew (11/5/2012)


    Actually if they are not saved I find that SSMS does tend to prompt you if you want to open previously opened Query Editor windows. You get a window with the file names and whether or not you want to open them. This is if SSMS is closed unexpectedly though.

    Hi,

    Yes I have that too, although it's hard to see if it's consistent or not. Was just hoping there was a flag which re-opened them, regardless of their saved state.

    If it's not there then I'm suprised that MS has not implemented it as it's seems built into must text editors, browser and other programs.

  • thedavegray (11/5/2012)


    Joie Andrew (11/5/2012)


    Actually if they are not saved I find that SSMS does tend to prompt you if you want to open previously opened Query Editor windows. You get a window with the file names and whether or not you want to open them. This is if SSMS is closed unexpectedly though.

    Hi,

    Yes I have that too, although it's hard to see if it's consistent or not. Was just hoping there was a flag which re-opened them, regardless of their saved state.

    If it's not there then I'm suprised that MS has not implemented it as it's seems built into must text editors, browser and other programs.

    You can try Redgate's SQL Tab Magic (currently free if I'm not mistaken), it does what you want from SSMS and even better 🙂

    It also keeps track of tabs you closed yourself.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • You can try Redgate's SQL Tab Magic (currently free if I'm not mistaken), it does what you want from SSMS and even better 🙂

    It also keeps track of tabs you closed yourself.

    Hi, that is interesting. It only works in SSMS 2008, not 2012 and it looks like they may bundle with Sql prompt in the future.

    SQL Tab Magic helps you keep track of all your tabs within SQL Server Management Studio. Although currently a free preview application, it may become a feature in an upcoming version of SQL Prompt.

    but for now I'm sure using SSMS 2008 is not the end of the world 🙂

  • I don't use it myself but i only hear good things about the SSMS Tools pack by Mladen Prajdic, I think that does what you looking for and works on pretty much every edition. and is free 🙂

    [/url]

  • n00bDBA (11/6/2012)


    I don't use it myself but i only hear good things about the SSMS Tools pack by Mladen Prajdic, I think that does what you looking for and works on pretty much every edition. and is free 🙂

    [/url]

    That's quite a set of free tools, thanks for the info.

Viewing 7 posts - 1 through 6 (of 6 total)

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