S D
sqlserver667 at yahoo.com
Mon May 3 07:04:20 CDT 2004
Hi group, I'm creating an impact analysis for my first really big SQL server project. I need to fire a lot (30+) sp's. I want to do this using a DTS package. I think a job is not intended for this and a job is too slow. Question regarding DTS: Does a DTS work like a transaction? So if one SP fails will all actions rollback? TIA Sander --------------------------------- Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs