Re: OT- DBA question SQL2K

2004-12-12 Thread Dana
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

OT- DBA question SQL2K

2004-12-10 Thread Eric Creese
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