non-expert opinion: afaik there is no difference. The wizard generates the same code. It is just easier and probably less prone to error. On the other hand TSQL may offer more flexibility, not sure.
Dana On Fri, 10 Dec 2004 11:30:07 -0600, Eric Creese <[EMAIL PROTECTED]> wrote: > When setting up backup strategies would you rather wrtie the commands and > save them in a job and schedule them or use the Data Maintainence Plan Wizard? > > I simply write the code and stick it in jobs and it works fine, however I got > some people her telling me to use the Wizard because jobs are unreliable. But > the Wizard simply creates a job that is scheduled the same way so I do. I do > not see what the difference is at all. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

