?
Solved

MS SQL Management Studio Overtype mode

Posted on 2013-06-10
4
Medium Priority
?
1,116 Views
Last Modified: 2013-06-25
I have an issue with a windows 7 pro computer and I'm only having this problem within SQL management studio. When I double click within the code pane--for example if I try to highlight a line of code, or if I simply double click within empty space--the text cursor changes to overtype mode. It's very frustrating because I then have to click the insert button every time I double click. If I try this in any other application--word, notepad, etc, I don't have this problem.

Thanks in advance
0
Comment
Question by:BitTrekker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 49

Expert Comment

by:PortletPaul
ID: 39236938
abnormal insert in an editor = not nice, and I'm not certain any of this will help I'm afraid:
msdn ssms documentation seems to discuss 2005 or 2012 so I apologize in advance if its not the right version:

SQL Server Management Studio offers users two keyboard schemes. 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.
http://msdn.microsoft.com/en-us/library/ms174205(v=sql.100).aspx

Not sure if IntelliSense is relevant either - might be
http://msdn.microsoft.com/en-US/library/ms173743(v=sql.110).aspx (2012)
http://msdn.microsoft.com/en-US/library/ms173743(v=sql.90).aspx (2005: shouldn't be relevant really - but what the heck)

getting even more generic now:
Query and Text Editors (SQL Server Management Studio) - 2012
http://msdn.microsoft.com/en-us/library/ms173477.aspx

Editing Scripts and Files in SQL Server Management Studio - 2005
http://msdn.microsoft.com/en-us/library/ms173457(v=sql.90).aspx

wish I had the simple fix for you - but don't.
0
 
LVL 13

Expert Comment

by:sameer2010
ID: 39237069
Hi,

Can you go to Tools -> Options -> Keyboard and select Default scheme and click reset?

Thanks,
Sam
0
 
LVL 23

Accepted Solution

by:
nemws1 earned 2000 total points
ID: 39238120
Are you running any clipboard or other keyboard handling utilities?  I had something similar happen to me (Ctrl-C to copy didn't work in SSMS) and it turned out to be a bad line in my AutoHotKey configuration file (3rd party app that does keyboard shortcuts).  Maybe something similar in your case??
0
 
LVL 1

Author Closing Comment

by:BitTrekker
ID: 39276058
Thanks, it was a third party addon. User wasn't sure how it got there.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question