Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to disable the 'shift+space' shortcut in SQL Server Management Studio 2008?

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?

like image 581
Matthew Avatar asked Jul 21 '11 16:07

Matthew


People also ask

How do I turn off overtype in SSMS?

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.

How do I change keyboard shortcuts in SSMS?

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.

How do I enable expand collapse in SQL Server 2008?

Open your query and then go to Edit > Outlining > Toggle All Outlining. This will toggle (i.e. expand/collapse) all nodes in the query.


1 Answers

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.

like image 164
Aaron Bertrand Avatar answered Sep 20 '22 20:09

Aaron Bertrand