MS SQL Management Studio Overtype mode

Posted on 2013-06-10
Medium Priority
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
Question by:BitTrekker
LVL 49

Expert Comment

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.

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

Editing Scripts and Files in SQL Server Management Studio - 2005

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

Expert Comment

ID: 39237069

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

LVL 23

Accepted Solution

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??

Author Closing Comment

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 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