Help! I am having an rage day in SSMS (auto-deletion of closing parenthesis)

  • So I've been working with SQL for a long long time, and I have noticed this little feature of the editor being around for a long long time too (although not quite as long). But today, I am getting absolutely horrendously mad at the fact that SSMS sometimes ignores characters you type when those characters are normally part of a matched pair.

    For example,

    - go into SSMS and type select foo()

    - put the cursor after the opening parenthesis

    - type a closing parenthesis... NO! It doesn't get typed!

    Today, for some reason, I am finding this unbearable. Do want I want, don't tell me what I want to do! Gaaaagh!

    I'm not sure if this is part of SSMS, or part of an addin. I have the SSMS tools pack and SQL Prompt, both of which seem like they could be doing this. I vaguely remember seeing something about "prevent accidental closing (something)" at some point, but 20 minutes of searching through the menus in SSMS leaves me without progress.

    Can anyone save me? I might have to go home from work and have a lie down if I can't turn off this "feature".

  • Must be an addin my SSMS 2008/2012 let's me type ok.

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

  • Want a cool sig (10/31/2012)


    Must be an addin my SSMS 2008/2012 let's me type ok.

    same here I'm using SSMS Tools in 2008 and SSMSBoost on the SSMS 2012 both allow me to do what I want.

    Though I do sometimes HATE autocomplete especially when it auto completes with a reserved word thats similar to afield/table name.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply