• curious_sqldba (5/17/2013)


    I have sql server 2012 and 2008R2 installed on my local.Prior to 2012 installation, i would just open SSMS from start by typing 'ssms', after 2012 installation if it type 'ssms' it would open management studio for 2012. Seems like 2008R2 and 2012 have same extensions for SSMS, is there way to just open 2008R2 management studio from start?

    For me its the other way round; if i type ssms it open up the 2008R2 SSMS. I don't think there is any clear way to open it up.

    The other silliness/(maybe trivial for some) would be :

    I have kept keyboard shortcuts for SP_HELPTEXT and when you highlight the object and run the shortcut, I copy the object definition in a new window to carry on with my work. SSMS 2012 inserts an extra line/s in the object definition. I have no clue why they modified that behavior. Don't fix it, if ain't broke.