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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Help! I am having an rage day in SSMS...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Don Halloran

Posted Tuesday, October 30, 2012 6:28 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 312, Visits: 1,041

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".

allmhuran.com - download the SSMSDeploy addin for SSMS 2008
Blog on sqlservercentral

Post #1379114

Want a cool Sig

Posted Wednesday, October 31, 2012 7:04 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:58 PM
Points: 221, Visits: 452

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

---------------------------------------------------------------
Mike Hahn - Future MCM 2025 Smile

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 Cool

I want to win the lotto BigGrin

I want a gf like Tiffa w00t

Post #1379289

Jason-299789

Posted Wednesday, October 31, 2012 7:35 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:30 AM
Points: 803, Visits: 2,124

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

Post #1379303

« Prev Topic | Next Topic »

Permissions