Hi Friends,
SQL Server Management Studio offers a wide variety of Keyboard Shortcuts. By default, it uses the Standard scheme, with keyboard shortcuts based on Microsoft Visual Studio. A second scheme, called SQL Server 2000, closely resembles the tools from SQL Server 2000, in particular the keyboard shortcuts from the Query Analyzer. In a few cases, SQL Server Management Studio cannot offer the keyboard shortcuts from Query Analyzer. To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. Select the desired keyboard scheme on the Environment, Keyboard page.
Microsoft has provided a complete Bible of Keyboard Shortcuts @ http://msdn.microsoft.com/en-us/library/ms174205.aspx
These are few shortcuts worth to mention:
IntelliSense Shortcuts
Action | Standard |
List members | CTRL+SPACE or CTRL+J |
Complete word | ALT+RIGHT ARROW |
Parameter information | CTRL+SHIFT+SPACE |
Refresh Local Cache | CTRL+SHIFT+R |
Jump between syntax pairs | CTRL+] |
Text Manipulation in Code Editor Shortcuts
Action | Standard |
Change the selected text to lowercase | CTRL+SHIFT+L |
Change the selected text to uppercase | CTRL+SHIFT+U |
Move selected lines to the left on tab stop | SHIFT+TAB |
Log Viewer Shortcuts
Action | Standard |
Refresh | F5 |
Move between the Select logs pane and the Log file summary pane | F6 |
Move to the Log file summary pane | ALT+S |
Load a new log | CTRL+SHIFT+L |
Export a log | CTRL+SHIFT+E |
Filter a log | CTRL+SHIFT+F |
Search in a log | CTRL+SHIFT+S |
Replication Monitor Shortcuts
Action | Standard |
Refresh | F5 |
Open a detail window from a grid | ENTER |
For More Shortcuts visit: http://msdn.microsoft.com/en-us/library/ms174205.aspx
Regards
Sarabpreet Anand
Like us on FaceBook | Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook
Follow me on Twitter | Follow me on FaceBook