SQL Server 2008 got released and there are lot of new features that takes SQL Server to the next level for sure. This post helps sql server developers in solving a shortcut problem. For any SQL Developer or DBA the most common short cuts are Ctrl N and Ctrl+R. Unfortunately Ctrl N short cut is not working in SQL 2008 with the default installation.
Now we’ll see how to resolve this issue. Ctrl+N Ctrl+N short cut is not working in SQL 2008 SSMS. We can easily fix it by changing the KeyBoard to SQL 2000 from Standard. To Change it
Tools –> Options –> Environment –> Keyboard –> Keyboard Schema Change it to SQL Server 2000.
Once this change is completed now you find that Ctrl+N is working. When we press Cntr+N a new query window will be opened.
Along with this there is an other short cut that will be very helpful for formatting T-SQL code which is Shift + K+ \.
When you opened a stored procedure and pasted it on Query Editor it look likes a bulky element and obviously difficult to understand. Just select the entire code and Press
