Month: July 2012

Management Studio 2012 – Save Table Changes

In SQL Server 2008/2012 the default table designer behavior is to disallow you from saving changes to table that require the designer to delete and recreate your table. In SQL Server 2005 SSMS the default setting allowed you to save your change by acknowledging a message prompted. If you’d like SSMS 2008 or 2012 to behave the same way your SSMS 2005 did, just follow these simple steps:

1.    Open SQL Management Studio

2.    Click menu Tools > Options

3.    In the Options window click Designers

4.    On the right pane, uncheck the checkbox that says Prevent saving changes that require table re-creation

5.    Click the OK button

You should be all set at this point. Test it out by opening the table designer, making your changes, and saving them.

 

SQL Management Studio 2012 (SSMS) Keyboard Shortcuts

So I’ve installed SQL Server 2012 on my Windows 7 machine and have encountered an unexpected issue that drove me absolute bonkers. I make extensive use of keyboard shortcuts for comments code, showing/hiding results panes, auto formatting code, etc… In the new SQL Management Studio much to my surprise, the good old fashion CRTL+R shortcut to toggle the results pane did not work. My first instinct was to try different combinations of shortcuts like CRTL+R+R or CRTL+D+R etc… Nothing worked. So I did some googling and found the following MS article http://msdn.microsoft.com/en-us/library/ms174205.aspx which states that the Ctrl+R shortcut is suppose to work.

Luckly, after some more searching I stumbled upon this MSDN blog http://blogs.msdn.com/b/managingsql/archive/2011/07/13/enhanced-keyboard-shortcuts-in-ssms-in-denali.aspx which helped me figure out how to fix it. What I learned is that SSMS 2012 ships with two different keyboard schemes “Default” and “Visual Studio 2010 Compatible”. Even though mine was set to Default, my Ctrl+R shortcut still didn’t work. So let me cut to the chase, here’s how you fix it:

1.    Open SSMS 2012

2.    Click menu Tools > Options

3.    Expand Environment > Keyboard

4.    Select “Default” if it isn’t already and click the Reset button

5.    Click the OK button

 

At this point, you can test your shortcut and you will find that it now works as expected.