Anyone knows how to purge old forum messages.  I would like to auto purge messages that are 3 months old.

 By any chance do you or anyone have the SQL query or know which tables to touch?  I don't know the relationships of the tables and just a little concern if i touch one i may miss some tables to update.  Thanks in advance!

Try this ...  AFTER YOU BACKUP THE DATABASE !!!!

select distinct [ThreadID] from [dbo].[Forum_Posts] where [CreatedDate] < '01-jan-2009'

This will display all threadIDs that have a CreatedDate < a given date -- here 01-jan-2009.

I would then verify that this is correct by selecting a ThreadID and performing (1234 is an example -- change as needed)

select * from [dbo].[Forum_Threads] where ThreadID = 1234

then if ready then delete the records - change the date as required -- Did you backup the database ?

delete from [dbo].[Forum_Threads] where ThreadID in (
    select distinct [ThreadID] from [dbo].[Forum_Posts] where [CreatedDate] < '01-jan-2009')

the cascade deletes will remove all other related records from the forum tables.  This will take some time depending on the number of threads involved.

Paul.