SQL Query Analyzer -- Number of Undo Buffers

Visual Studio .NET has really spoiled me by allowing an insane amount of Ctrl Z's to be stored in memory (I haven't actually counted how many, but it's enough so that if I really f*ck up, I can usually Ctrl Z my way back to sanity).  SQL Query Analyzer maxes out at 20, or so the message box tells me when I try to set this to a number larger than this in Tools, Options.  I finally got fed up with this and did a little registry manipulation; if anyone is interested, the registry key is HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer\Options\EditorTab\NumUndoBufs\.  I set this value to 100 and haven't run into any issues, unless you open Tools, Options and click OK...you will get the message box nagging you to set this to a number between 1-20.  If you export the reg key mentioned above, you can just double click it to get your preferred setting back.  I am guessing numbers higher than 100 are fine, but if I'm making that many changes to a SQL script, I will probably save the original query to notepad first.  Happy querying.

Comments

# Bob said:

I thought using that many undo's in VS was part of the reason for the development of Sourcesafe... ;)

Thursday, April 22, 2004 9:39 PM
# protected virtual void jaysonBlog { said:

One thing that really bugs me about blogs is that it’s still really damn hard to find specific...

Friday, December 30, 2005 1:38 AM