Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Management Studio overwriting instead of inserting text while typing

Discussion in 'SQL Server Scripts and Tools' started by Peter Schmitz, Mar 24, 2020.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    For some reason, all of a sudden my SQL Server Management Studio (SSMS) started behaving somewhat odd; where other applications behaved properly, allowing me to type and the text simply being inserted, SSMS was overwriting text.

    I tested multiple other applications (Visual Studio, Notepad), but all functioned normally, so clearly this was some issue on the SSMS side.

    As it turns out, within SSMS, you can actually define the behavior of the text editor, and alternate between Insert and Overwrite. The place to find it is somewhat obscure, though, and it took me far longer than I want to admit to find it.

    In the status bar, all the way at the bottom of the SSMS window, look for "OVR" (OVR for Overwrite):

    upload_2020-3-24_11-40-28.png

    Double-click that, and the value will change to "INS" (Insert):

    upload_2020-3-24_11-37-7.png

    And you will have fixed your problem.
    Last edited: Mar 24, 2020

Share This Page