SQL Enterprize Manager has a Maintenance Wizard. I would go thru that and
accept the defaults.
Then you will see the sheduled tasks. You can then add the checkdb, create
a script to delete start records & add that. There should be a command to
truncate also but it slips my mind at the moment.
John C. Lange, Sr. PALACE dot NET, INC.
firstname.lastname@example.org MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)