Even wonder where all the settings for a module is kept ... in the ModuleSettings table - duh!   Ok ... maybe it's not that obvious to some.  But the ModuleSettings table holds the keys to the kingdom for certain modules.  In fact, often the module export is just a copy of the items in the Modulesetting table for the specific module.

The table layout is straight forward ... ModuleID, SettingName, SettingValue.  So if the moduleID is 400 then to view all settings for moduleID 400, execute the following select

Select * from ModuleSettings where ModuleID = 400 order by SettingName

This Select will return all the specifics settings for Module 400.  Note: not all

ModuleID  SettingName          SettingValue
--------- -------------------- --------------------------------------
400       EventAfterMessage    !!!
400       EventBeforeMessage   until Vancouver Olympics
400       EventDisplay         14
400       EventDuringMessage   Go Canada Go
400       EventProcess         1030
400       EventStartDate       2010-Feb-12 04:00:00
400       EventStopDate        2010-Mar-01 04:00:00
400       EventSuffix         
400       EventTitle           Vancouver Winter Olympics

As you can see the results contain obvious value related to the my T-Minus Module.

So what modules do place their settings in the ModuleSettings table?  Use the following to find out. 

Select M.ModuleID, MD.FriendlyName 
    from dbo.ModuleDefinitions MD
     join dbo.Modules M on M.ModuleDefID = MD.ModuleDefID
where
    M.ModuleID in (Select distinct ModuleID from ModuleSettings)
order by
    M.ModuleID

This select will display all the modules located in the ModuleSettings Table and their associated "friendly name".  You can now determine what is stored away in your ModuleSettings table.

I don't recommend playing with the values unless you absolutely need too.  You can cause alot of damage very quickly.  So Look, but don't touch!

Paul.