Did You Know? Nobody upgraded the SET OPTIONS screen in SQL Server Management Studio

re: Did You Know? Nobody upgraded the SET OPTIONS screen in SQL Server Management Studio

James Luetkehoelter — Wed, 18 Jul 2007 09:34:34 GMT

Nice to point out Kalen - missing Snapshot in there is one that really infuriates me. I encourage those that aren't strong in TSQL (ahem, more than I'd like to admit to myself) to make the change in SSMS, script it out, then run it, then save the script in a folder with the current date in the name - instant change history! However, I can't do that here (or in some other places).

One unchanged piece in SSMS that drives me crazy is the backup dialog box. It still has that open text window at the bottom where you can add multiple disk devices. I can't count the number of times when I've been working with a client during a restore and realized that they had 5-10 files in there, not realizing that it was stripping to each one (since you could high-light a single file). ARGH!

re: Did You Know? Nobody upgraded the SET OPTIONS screen in SQL Server Management Studio

Brennan Gordon — Thu, 19 Jul 2007 07:07:08 GMT

I have been working with SQL 2000 and 2005 for quite a while now and have never really bothered about these settings. I tend to just leave things as default.

Am I horribly ignorant or just typical? Is there some amazing things that I am missing by not taking advantage of these client-side settings?

re: Did You Know? Nobody upgraded the SET OPTIONS screen in SQL Server Management Studio

Kalen Delaney — Fri, 20 Jul 2007 02:58:38 GMT

Hi Brennan

I think there are probably many people who never have a need to adjust any of these, and in most cases you will be better off if you leave these settings at their default. I think it's just curious that since they have the option of setting session options in a dialog box, they should have the options reflect what's possible in the version of the product that the tool is supposed to go with.

~Kalen