SQLServer Mgmt Studio 2005

SQLServer Mgmt Studio 2005 (Std keyset) Keyboard Shortcuts
Menu Activation Keyboard Shortcuts
ALT	Move to the SQL Server Management Studio menu bar
ALT+HYPHEN	Activate the menu for a tool component
Shift+F10	Display the context menu
CTRL+N	Display the New File dialog box to create a file
CTRL+Shift+N	Display the New Project dialog box to create a new project
CTRL+O	Display the Open File dialog box to open an existing file
CTRL+Shift+O	Display the Open Project dialog box to open an existing project
CTRL+Shift+A	Display the Add New Item dialog box to add a new file to the current project
ALT+Shift+A	Display the Add Existing Item dialog box to add an existing file to the current project
CTRL+Shift+Q	Display the Query Designer
ESC	Close a menu or dialog box, canceling the action
Windows Management and Toolbar Keyboard Shortcuts
CTRL+F4	Close the current MDI child window
CTRL+P	Print
ALT+F4	Exit
Shift+ALT+ENTER	Toggle full screen mode
Shift+ESC	Close the current tool window
CTRL+TAB	Cycle through the next MDI child windows
CTRL+Shift+TAB	Cycle through the previous MDI child windows
Shift+ALT	Move to the current tool window toolbar
ALT+F6	Move to the next tool window
Shift+ALT+F6	Move to the previously selected window
F8	Display Object Explorer
CTRL+ALT+R	Display Registered Servers
CTRL+ALT+T	Display Template Explorer
CTRL+ALT+L	Display Solution Explorer
F7	Display the Summary Window
F4	Display the Properties Window
CTRL+ALT+X	Display the Toolbox
CTRL+K, CTRL+W	Display the Bookmarks Window
CTRL_ALT+R	Display the Browser Window
Cursor Movement Keyboard Shortcuts
LEFT ARROW	Move the cursor left
RIGHT ARROW	Move the cursor right
UP ARROW	Move the cursor up
DOWN ARROW	Move the cursor down
HOME	Move the cursor to the beginning of the line
END	Move the cursor to the end of the line
CTRL+HOME	Move the cursor to the beginning of the document
CTRL+END	Move the cursor to the end of the document
PAGE UP	Move the cursor up one screen
PAGE DOWN	Move the cursor down one screen
CTRL+ RIGHT ARROW	Moves the cursor one word to the right
CTRL+ LEFT ARROW	Moves the cursor one word to the left
Text Selection Keyboard Shortcuts
CTRL+Shift+ HOME	Select text from the cursor to the beginning of the document
CTRL+Shift+END	Select text from the cursor to the end of the document
Shift+HOME	Select text from the cursor to the start of the current line
Shift+END	Select text from the cursor to the end of the current line
Shift+ DOWN ARROW	Select text down line by line starting from the cursor
Shift+UP ARROW	Select text up line by line starting from the cursor
Shift+ALT+ UP ARROW	Move the cursor up one line, extending the selection
Shift+ PAGE UP	Extend selection up one page
Shift+ PAGE DOWN	Extend selection down one page
CTRL+A	Select the entire current document
CTRL+W	Select the word containing the cursor, or the closest word
CTRL+=	Select the current location in the editor, back to the previous location in the editor
CTRL+Shift+ PAGE UP	Extend the selection to the top of the current window
CTRL+Shift+ PAGE DOWN	Move the cursor to the last line in view, extending the selection
CTRL+Shift+ RIGHT ARROW	Extend the selection one word to the right
CTRL+Shift+ LEFT ARROW	Extend the selection one word to the left
CTRL+Shift+ALT+ RIGHT ARROW	Move the cursor to the right one word, extending the selection
CTRL+Shift+ALT+ LEFT ARROW	Move the cursor to the left one word, extending the selection
Bookmark Keyboard Shortcuts
CTRL+K, CTRL+K	Set or remove a bookmark at the current line
CTRL+K, CTRL+N	Next bookmark
CTRL+K, CTRL+P	Previous bookmark
CTRL+K, CTRL+L	Clear bookmarks
Tree Control Keyboard Shortcuts
- (minus - on numeric keypad)	Collapse tree nodes
* (on the numeric keypad)	Expand all tree nodes
CTRL+UP ARROW	Scroll the tree control up in the window
CTRL+ DOWN ARROW	Scroll the tree control down in the window
Code Editor Keyboard Shortcuts
Shift+ALT+ENTER	Toggle the full-screen display
CTRL+UP ARROW	Scroll text up one line
CTRL+ DOWN ARROW	Scroll text down one line
CTRL+Z	Reverse the last editing action
CTRL+Shift+Z or CTRL+Y or ALT+Shift+BACKSPACE	Restore the previously undone edit
CTRL+S	Save the selected item
CTRL+Shift+S	Save all
CTRL+F4	Close
CTRL+P	Print
ALT+F4	Exit
CTRL+Shift+DEL	Delete all text in the current file
CTRL+G	Display the Go To Line dialog box
TAB	Increase line indent
Shift+TAB	Decrease line indent
CTRL+Shift+U	Make the selected text upper case
CTRL+Shift+L	Make the selected text lower case
CTRL+K, CTRL+C	Make the selected text a comment
CTRL+K, CTRL + U	Uncomment the selected text
CTRL+Q	Open a new query with current connection
ALT+F8	Open database in Object Explorer
CTRL+Shift+M	Specify values for template parameters
F5 or CTRL+E or ALT+X	Execute the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+F5	Parse the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+L	Display the estimated execution plan
ALT+BREAK	Cancel the executing query
CTRL+M	Include actual execution plan in the query output
CTRL+D	Output results in a grid
CTRL+T	Output results in text format
CTRL+Shift+F	Output results to a file
CTRL+R	Show or hide the query results pane
F6	Toggle between query and results pane
CTRL+F6	Move to the next active window in Management Studio
ALT+ENTER	Auto hide all
CTRL+W	Windows
Text Manipulation in Code Editor Keyboard Shortcuts
ENTER or Shift+ENTER	Insert a new line
CTRL+T	Swap the characters on either side of the cursor
DELETE	Delete on character to the right of the cursor
BACKSPACE or Shift+ BACKSPACE	Delete one character to the left of the cursor
TAB	Insert the number of spaces configured for the editor
CTRL+ENTER	Insert a blank line above the cursor
CTRL+Shift+ ENTER	Insert a blank line below the cursor
CTRL+Shift+L	Change the selected text to lowercase
CTRL+Shift+U	Change the selected text to uppercase
INSERT	Toggle between insertion mode and overtype mode
Shift+TAB	Move selected lines to the left on tab stop
CTRL+DELETE	Delete the word to the right of the cursor
CTRL+BACKSPACE	Delete the word to the left of the cursor
CTRL+Shift+T	Transpose the words on either side of the cursor
Microsoft IntelliSense Keyboard Shortcuts
CTRL+J	List members
ALT+RIGHT ARROW	Complete word
Document Window and Browser Keyboard Shortcuts
Shift+ALT+ENTER	Toggle full-screen mode
F6	Move to the next pane of a split pane view of a document
CTRL+Shift+F6 CTRL+Shift+TAB	Move to the previous document in the editor or designer
Shift+F6	Move to the previous pane of a document in split pane view
CTRL+ALT+R	Display the Browser Window
ALT+LEFTARROW	Back, display the previous page in the viewing history
ALT+RIGHTARROW	Forward, display the next page in the viewing history
Solution Explorer Keyboard Shortcuts
CTRL+ALT+L	Display Solution Explorer
CTRL+N	Display the New File dialog box to create a new file
CTRL+Shift+N	Display the New Project dialog box to create a new project
CTRL+O	Display the Open File dialog box to open an existing file
Help and Books Online Keyboard Shortcuts
F1	Help
CTRL+F1	Help on How Do I
CTRL+ALT+F1	Books Online Contents
CTRL+ALT+F2	Books Online Index
CTRL+ALT+F3	Help Search
CTRL+ALT+F4	Dynamic Help
CTRL+ALT+F	Help Favorites
Search Keyboard Shortcuts
CTRL+F	Display the Find dialog box
CTRL+H	Display the Replace dialog box
CTRL+I	Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search
F3	Find the next occurrence of the previous search text
Shift+F3	Find the previous occurrence of the search text
CTRL+F3	Find the next occurrence of the currently selected text
CTRL+Shift+F3	Find the previous occurrence of the currently selected text
CTRL+Shift+H	Display the Replace in Files dialog box
CTRL+Shift+I	Reverse incremental search so it starts at the bottom of the file and searches to the top
ALT+F3, B	Select or clear the Search up option in Find and Replace
ALT+F3, S	Stop the Find in Files search
ALT+F3, W	Select or clear the Find whole word option in Find and Replace
ALT+F3, P	Selects or clears the Wildcard option in Find and Replace
Cut and Paste Keyboard Shortcuts
CTRL+X or Shift+DELETE	Cut (delete the currently selected item and place it to the Clipboard)
CTRL+C or CTRL+INSERT	Copy to the Clipboard
CTRL+V or Shift+INSERT	Paste from the Clipboard at the insertion point
Log Viewer Keyboard Shortcuts
F5	Refresh
F6	Move between the Select logs pane and the Log file summary pane
ALT+S	Move to the Log file summary pane
CTRL+Shift+L	Load a new log
CTRL+Shift+E	Export a log
CTRL+Shift+F	Filter a log
CTRL+Shift+S	Search in a log
Activity Monitor Keyboard Shortcuts
F5	Refresh
CTRL+Shift+F	Filter the monitor display
Replication Monitor Keyboard Shortcuts
F5	Refresh
ENTER	Open a detail window from a grid
Replication Conflict Viewer Keyboard Shortcuts
F6	Define filter
F7	Apply filter
F8	Show all columns