Tuesday 7 February 2012

SQLServer Mgmt Studio 2005

SQLServer Mgmt Studio 2005 (Std keyset) Keyboard Shortcuts
Menu Activation Keyboard Shortcuts
ALTMove to the SQL Server Management Studio menu bar
ALT+HYPHENActivate the menu for a tool component
Shift+F10Display the context menu
CTRL+NDisplay the New File dialog box to create a file
CTRL+Shift+NDisplay the New Project dialog box to create a new project
CTRL+ODisplay the Open File dialog box to open an existing file
CTRL+Shift+ODisplay the Open Project dialog box to open an existing project
CTRL+Shift+ADisplay the Add New Item dialog box to add a new file to the current project
ALT+Shift+ADisplay the Add Existing Item dialog box to add an existing file to the current project
CTRL+Shift+QDisplay the Query Designer
ESCClose a menu or dialog box, canceling the action
Windows Management and Toolbar Keyboard Shortcuts
CTRL+F4Close the current MDI child window
CTRL+PPrint
ALT+F4Exit
Shift+ALT+ENTERToggle full screen mode
Shift+ESCClose the current tool window
CTRL+TABCycle through the next MDI child windows
CTRL+Shift+TABCycle through the previous MDI child windows
Shift+ALTMove to the current tool window toolbar
ALT+F6Move to the next tool window
Shift+ALT+F6Move to the previously selected window
F8Display Object Explorer
CTRL+ALT+RDisplay Registered Servers
CTRL+ALT+TDisplay Template Explorer
CTRL+ALT+LDisplay Solution Explorer
F7Display the Summary Window
F4Display the Properties Window
CTRL+ALT+XDisplay the Toolbox
CTRL+K, CTRL+WDisplay the Bookmarks Window
CTRL_ALT+RDisplay the Browser Window
Cursor Movement Keyboard Shortcuts
LEFT ARROWMove the cursor left
RIGHT ARROWMove the cursor right
UP ARROWMove the cursor up
DOWN ARROWMove the cursor down
HOMEMove the cursor to the beginning of the line
ENDMove the cursor to the end of the line
CTRL+HOMEMove the cursor to the beginning of the document
CTRL+ENDMove the cursor to the end of the document
PAGE UPMove the cursor up one screen
PAGE DOWNMove the cursor down one screen
CTRL+ RIGHT ARROWMoves the cursor one word to the right
CTRL+ LEFT ARROWMoves the cursor one word to the left
Text Selection Keyboard Shortcuts
CTRL+Shift+ HOMESelect text from the cursor to the beginning of the document
CTRL+Shift+ENDSelect text from the cursor to the end of the document
Shift+HOMESelect text from the cursor to the start of the current line
Shift+ENDSelect text from the cursor to the end of the current line
Shift+ DOWN ARROWSelect text down line by line starting from the cursor
Shift+UP ARROWSelect text up line by line starting from the cursor
Shift+ALT+ UP ARROWMove the cursor up one line, extending the selection
Shift+ PAGE UPExtend selection up one page
Shift+ PAGE DOWNExtend selection down one page
CTRL+ASelect the entire current document
CTRL+WSelect 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 UPExtend the selection to the top of the current window
CTRL+Shift+ PAGE DOWNMove the cursor to the last line in view, extending the selection
CTRL+Shift+ RIGHT ARROWExtend the selection one word to the right
CTRL+Shift+ LEFT ARROWExtend the selection one word to the left
CTRL+Shift+ALT+ RIGHT ARROWMove the cursor to the right one word, extending the selection
CTRL+Shift+ALT+ LEFT ARROWMove the cursor to the left one word, extending the selection
Bookmark Keyboard Shortcuts
CTRL+K, CTRL+KSet or remove a bookmark at the current line
CTRL+K, CTRL+NNext bookmark
CTRL+K, CTRL+PPrevious bookmark
CTRL+K, CTRL+LClear bookmarks
Tree Control Keyboard Shortcuts
- (minus - on numeric keypad)Collapse tree nodes
* (on the numeric keypad)Expand all tree nodes
CTRL+UP ARROWScroll the tree control up in the window
CTRL+ DOWN ARROWScroll the tree control down in the window
Code Editor Keyboard Shortcuts
Shift+ALT+ENTERToggle the full-screen display
CTRL+UP ARROWScroll text up one line
CTRL+ DOWN ARROWScroll text down one line
CTRL+ZReverse the last editing action
CTRL+Shift+Z or CTRL+Y or ALT+Shift+BACKSPACERestore the previously undone edit
CTRL+SSave the selected item
CTRL+Shift+SSave all
CTRL+F4Close
CTRL+PPrint
ALT+F4Exit
CTRL+Shift+DELDelete all text in the current file
CTRL+GDisplay the Go To Line dialog box
TABIncrease line indent
Shift+TABDecrease line indent
CTRL+Shift+UMake the selected text upper case
CTRL+Shift+LMake the selected text lower case
CTRL+K, CTRL+CMake the selected text a comment
CTRL+K, CTRL + UUncomment the selected text
CTRL+QOpen a new query with current connection
ALT+F8Open database in Object Explorer
CTRL+Shift+MSpecify values for template parameters
F5 or CTRL+E or ALT+XExecute the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+F5Parse the selected portion of the query editor or the entire query editor if nothing is selected
CTRL+LDisplay the estimated execution plan
ALT+BREAKCancel the executing query
CTRL+MInclude actual execution plan in the query output
CTRL+DOutput results in a grid
CTRL+TOutput results in text format
CTRL+Shift+FOutput results to a file
CTRL+RShow or hide the query results pane
F6Toggle between query and results pane
CTRL+F6Move to the next active window in Management Studio
ALT+ENTERAuto hide all
CTRL+WWindows
Text Manipulation in Code Editor Keyboard Shortcuts
ENTER or Shift+ENTERInsert a new line
CTRL+TSwap the characters on either side of the cursor
DELETEDelete on character to the right of the cursor
BACKSPACE or Shift+ BACKSPACEDelete one character to the left of the cursor
TABInsert the number of spaces configured for the editor
CTRL+ENTERInsert a blank line above the cursor
CTRL+Shift+ ENTERInsert a blank line below the cursor
CTRL+Shift+LChange the selected text to lowercase
CTRL+Shift+UChange the selected text to uppercase
INSERTToggle between insertion mode and overtype mode
Shift+TABMove selected lines to the left on tab stop
CTRL+DELETEDelete the word to the right of the cursor
CTRL+BACKSPACEDelete the word to the left of the cursor
CTRL+Shift+TTranspose the words on either side of the cursor
Microsoft IntelliSense Keyboard Shortcuts
CTRL+JList members
ALT+RIGHT ARROWComplete word
Document Window and Browser Keyboard Shortcuts
Shift+ALT+ENTERToggle full-screen mode
F6Move to the next pane of a split pane view of a document
CTRL+Shift+F6 CTRL+Shift+TABMove to the previous document in the editor or designer
Shift+F6Move to the previous pane of a document in split pane view
CTRL+ALT+RDisplay the Browser Window
ALT+LEFTARROWBack, display the previous page in the viewing history
ALT+RIGHTARROWForward, display the next page in the viewing history
Solution Explorer Keyboard Shortcuts
CTRL+ALT+LDisplay Solution Explorer
CTRL+NDisplay the New File dialog box to create a new file
CTRL+Shift+NDisplay the New Project dialog box to create a new project
CTRL+ODisplay the Open File dialog box to open an existing file
Help and Books Online Keyboard Shortcuts
F1Help
CTRL+F1Help on How Do I
CTRL+ALT+F1Books Online Contents
CTRL+ALT+F2Books Online Index
CTRL+ALT+F3Help Search
CTRL+ALT+F4Dynamic Help
CTRL+ALT+FHelp Favorites
Search Keyboard Shortcuts
CTRL+FDisplay the Find dialog box
CTRL+HDisplay the Replace dialog box
CTRL+IStart incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search
F3Find the next occurrence of the previous search text
Shift+F3Find the previous occurrence of the search text
CTRL+F3Find the next occurrence of the currently selected text
CTRL+Shift+F3Find the previous occurrence of the currently selected text
CTRL+Shift+HDisplay the Replace in Files dialog box
CTRL+Shift+IReverse incremental search so it starts at the bottom of the file and searches to the top
ALT+F3, BSelect or clear the Search up option in Find and Replace
ALT+F3, SStop the Find in Files search
ALT+F3, WSelect or clear the Find whole word option in Find and Replace
ALT+F3, PSelects or clears the Wildcard option in Find and Replace
Cut and Paste Keyboard Shortcuts
CTRL+X or Shift+DELETECut (delete the currently selected item and place it to the Clipboard)
CTRL+C or CTRL+INSERTCopy to the Clipboard
CTRL+V or Shift+INSERTPaste from the Clipboard at the insertion point
Log Viewer Keyboard Shortcuts
F5Refresh
F6Move between the Select logs pane and the Log file summary pane
ALT+SMove to the Log file summary pane
CTRL+Shift+LLoad a new log
CTRL+Shift+EExport a log
CTRL+Shift+FFilter a log
CTRL+Shift+SSearch in a log
Activity Monitor Keyboard Shortcuts
F5Refresh
CTRL+Shift+FFilter the monitor display
Replication Monitor Keyboard Shortcuts
F5Refresh
ENTEROpen a detail window from a grid
Replication Conflict Viewer Keyboard Shortcuts
F6Define filter
F7Apply filter
F8Show all columns

 

Subscribe to our Newsletter

Contact our Support

Email us: youremail@gmail.com

Our Team Memebers