When I am editting data in the "edit top 200 rows" tab, I frequently press 'shift+space' as I am entering capitalized data, which kicks me out of edit mode. This is extremely annoying, and reduces my typing speed to around ~10% of normal. Is there any way to disable this shortcut in SQL Server Management Studio 2008?
To start off, click “File” tab then choose “Options” to open the “Word Options” dialog box. Next click “Advanced” on the left column. Then uncheck the “Use Insert key to control overtype mode” box.
SQL Server Management Studio (SSMS) offers keyboard shortcuts. By default, it uses the SQL Server scheme, with keyboard shortcuts based on Visual Studio. To change the keyboard scheme or add more keyboard shortcuts, on the Tools menu, select Options. Select the desired keyboard scheme on the Environment, Keyboard page.
Open your query and then go to Edit > Outlining > Toggle All Outlining. This will toggle (i.e. expand/collapse) all nodes in the query.
Nope. This bug was closed as "won't fix" about two years ago (not enough people cared, I guess - only one person voted aside from me):
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=473303
Of course my suggestion is to use UPDATE statements rather than the quirky Edit Top n grid, which has several other problems in addition to this one.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With