Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 03-16-2007, 02:44 PM Thank God for Undo
Learning Newbie's Avatar
Defies a Status

Latest Blog Post:
Astounding Republican Paranoia
Posts: 5,662
Name: John Alexander
Trades: 0
I don't know about Query Analyzer, I haven't used it in a couple years now, and it gives me chills just to think about it.

But in Microsoft SQL Server Management Studio ( which kills off QA as well as Enterprise Mangler ), we seem to have unlimited undo. Yesterday I produced a stand-alone DTS package ( persisted as a structured file, and not managed by the server ), but now I've been asked to add one more thing to the package. I'm not sure if it's possible to get into the designer for the DTS file I created, but thanks to Ctrl-Z, I got all my code back.

Also, for anyone who works with indexed views a lot, if you go to Tools -> Options, you can tell the client tool to automatically set ARITHABORT on when you launch a new query window!!

As long as I'm sharing cool tips, I hope everyone knows about selecting a table name and then hitting Alt-F1? That one works even in Query Analyzer.
Learning Newbie is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 03-16-2007, 06:39 PM Re: Thank God for Undo
Extreme Talker

Posts: 189
Trades: 1
Thanks for the tip mate.
BTW, you can use repository, every time you make a change, you submit your change. And you can switch back to any revision just 2 clicks.
__________________

Please login or register to view this content. Registration is FREE

Last edited by yellow1912; 03-16-2007 at 06:40 PM..
yellow1912 is offline
Reply With Quote
View Public Profile Visit yellow1912's homepage!
 
Reply     « Reply to Thank God for Undo
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.29477 seconds with 12 queries