This stored procedure returns all of settings for the for the specified module. The settings are stored in the ModuleSettings table as a name/value pair. The input parameter is the ModuleID.
Definition:CREATE PROCEDURE GetModuleSettings ( @ModuleID int ) AS SELECT SettingName, SettingValue FROM ModuleSettings WHERE ModuleID = @ModuleIDDatabase Tables Used:
ModuleSettings: Each record in the ModuleSettings table contains a name/value pair that represents a setting used by a module within the portal. Each setting item contains a ModuleID to permit all settings to be retrieved in a single query.