What do i need to do to reset the tables to the original contents of the cognos namespace without reinstalling the product. is there a SQL available?
You can stop Cognos service first, then drop and recreate content store database, restart Cognos service.
check the following location for a cleanup script: <c8 install>configuration/schema/<db type>/content.
There should be some scripts for cleaning your cstore...