Way to go Anthony <ha>. You just cleaned the poor guy out.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:06 PM To: CF-Talk Subject: RE: Purge cfVar db using SQL script MISTAKE!!!! i didn't see that you only wanted to get rid of records over 30 days. sorry about that. the statements i gave you before would delete EVERYTHING in the tables. again sorry. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:02 PM To: CF-Talk Subject: RE: Purge cfVar db using SQL script make sure you use truncate table cfdata truncate table cfglobal it's faster then DELETE FROM cfdata DELETE FROM cfglobal also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more about it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:49 PM To: CF-Talk Subject: RE: Purge cfVar db using SQL script Miles, I may be mistaken, but I think there is a custom tag or script on the gallery that can take care of this task for you. Mark -----Original Message----- From: Miles Fawcett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:31 AM To: CF-Talk Subject: Purge cfVar db using SQL script We are using CF5 in a clustered environment and would like to purge the cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am interested in anyone has a script they know works are has any insight into this approach. We would like to purge all records older than 30 days. Thanks, Miles Miles Fawcett, President Interactive Applications Group (iapps) tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271 Washington * New York * San Francisco * Boston ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
