After some initial tests to make sure everything was OK with a UGC installation I want to clear down all test comments/rating/stats before we hand it over.

Is there a "supported" way to does this quickly - rather than finding each comment within the Tridion GUI and deleting it (which wouldn't help with ratings anyway).

I'd like to simply run an few SQL DELETE statements against each table but just wanted to check if there was any reason why I shouldn't.


1 Answer 1


It might be easier to use the installation scripts to generate a new UGC database and simply drop (backing up first of course :)) the old db all together?

  • Nice bit of lateral thinking John! This is 2011 SP1 HR1 so I guess you mean re-run the TDM to create a new db?
    – Neil
    Commented Nov 18, 2013 at 15:12
  • 1
    The DB create scripts are also available for 2011 SP1, in the scripts folder of the installer. Commented Nov 18, 2013 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.