DotNetNuke 5.6 - procedure parameters

All procedure parameters

procedure	type	parameter	datatype	length	in/out
AddAffiliate	P	@VendorId	int	4	IN
AddAffiliate	P	@StartDate	datetime	8	IN
AddAffiliate	P	@EndDate	datetime	8	IN
AddAffiliate	P	@CPC	float	4	IN
AddAffiliate	P	@CPA	float	4	IN
AddAuthentication	P	@PackageID	int	4	IN
AddAuthentication	P	@AuthenticationType	nvarchar	100	IN
AddAuthentication	P	@IsEnabled	bit	0	IN
AddAuthentication	P	@SettingsControlSrc	nvarchar	250	IN
AddAuthentication	P	@LoginControlSrc	nvarchar	250	IN
AddAuthentication	P	@LogoffControlSrc	nvarchar	250	IN
AddAuthentication	P	@CreatedByUserID	int	4	IN
AddBanner	P	@BannerName	nvarchar	100	IN
AddBanner	P	@VendorId	int	4	IN
AddBanner	P	@ImageFile	nvarchar	100	IN
AddBanner	P	@URL	nvarchar	255	IN
AddBanner	P	@Impressions	int	4	IN
AddBanner	P	@CPM	float	4	IN
AddBanner	P	@StartDate	datetime	8	IN
AddBanner	P	@EndDate	datetime	8	IN
AddBanner	P	@UserName	nvarchar	100	IN
AddBanner	P	@BannerTypeId	int	4	IN
AddBanner	P	@Description	nvarchar	2000	IN
AddBanner	P	@GroupName	nvarchar	100	IN
AddBanner	P	@Criteria	bit	0	IN
AddBanner	P	@Width	int	4	IN
AddBanner	P	@Height	int	4	IN
AddContentItem	P	@Content	nvarchar	-1	IN
AddContentItem	P	@ContentTypeID	int	4	IN
AddContentItem	P	@TabID	int	4	IN
AddContentItem	P	@ModuleID	int	4	IN
AddContentItem	P	@ContentKey	nvarchar	250	IN
AddContentItem	P	@Indexed	bit	0	IN
AddContentItem	P	@CreatedByUserID	int	4	IN
AddContentType	P	@ContentType	nvarchar	250	IN
AddDesktopModule	P	@PackageID	int	4	IN
AddDesktopModule	P	@ModuleName	nvarchar	128	IN
AddDesktopModule	P	@FolderName	nvarchar	128	IN
AddDesktopModule	P	@FriendlyName	nvarchar	128	IN
AddDesktopModule	P	@Description	nvarchar	2000	IN
AddDesktopModule	P	@Version	nvarchar	8	IN
AddDesktopModule	P	@IsPremium	bit	0	IN
AddDesktopModule	P	@IsAdmin	bit	0	IN
AddDesktopModule	P	@BusinessController	nvarchar	200	IN
AddDesktopModule	P	@SupportedFeatures	int	4	IN
AddDesktopModule	P	@CompatibleVersions	nvarchar	500	IN
AddDesktopModule	P	@Dependencies	nvarchar	400	IN
AddDesktopModule	P	@Permissions	nvarchar	400	IN
AddDesktopModule	P	@CreatedByUserID	int	4	IN
AddDesktopModulePermission	P	@PortalDesktopModuleID	int	4	IN
AddDesktopModulePermission	P	@PermissionID	int	4	IN
AddDesktopModulePermission	P	@RoleID	int	4	IN
AddDesktopModulePermission	P	@AllowAccess	bit	0	IN
AddDesktopModulePermission	P	@UserID	int	4	IN
AddDesktopModulePermission	P	@CreatedByUserID	int	4	IN
AddEventLog	P	@LogGUID	varchar	36	IN
AddEventLog	P	@LogTypeKey	nvarchar	35	IN
AddEventLog	P	@LogUserID	int	4	IN
AddEventLog	P	@LogUserName	nvarchar	50	IN
AddEventLog	P	@LogPortalID	int	4	IN
AddEventLog	P	@LogPortalName	nvarchar	100	IN
AddEventLog	P	@LogCreateDate	datetime	8	IN
AddEventLog	P	@LogServerName	nvarchar	50	IN
AddEventLog	P	@LogProperties	ntext	1073741823	IN
AddEventLog	P	@LogConfigID	int	4	IN
AddEventLogConfig	P	@LogTypeKey	nvarchar	35	IN
AddEventLogConfig	P	@LogTypePortalID	int	4	IN
AddEventLogConfig	P	@LoggingIsActive	bit	0	IN
AddEventLogConfig	P	@KeepMostRecent	int	4	IN
AddEventLogConfig	P	@EmailNotificationIsActive	bit	0	IN
AddEventLogConfig	P	@NotificationThreshold	int	4	IN
AddEventLogConfig	P	@NotificationThresholdTime	int	4	IN
AddEventLogConfig	P	@NotificationThresholdTimeType	int	4	IN
AddEventLogConfig	P	@MailFromAddress	nvarchar	50	IN
AddEventLogConfig	P	@MailToAddress	nvarchar	50	IN
AddEventLogType	P	@LogTypeKey	nvarchar	35	IN
AddEventLogType	P	@LogTypeFriendlyName	nvarchar	50	IN
AddEventLogType	P	@LogTypeDescription	nvarchar	128	IN
AddEventLogType	P	@LogTypeOwner	nvarchar	100	IN
AddEventLogType	P	@LogTypeCSSClass	nvarchar	40	IN
AddEventMessage	P	@EventName	nvarchar	100	IN
AddEventMessage	P	@Priority	int	4	IN
AddEventMessage	P	@ProcessorType	nvarchar	250	IN
AddEventMessage	P	@ProcessorCommand	nvarchar	250	IN
AddEventMessage	P	@Body	nvarchar	250	IN
AddEventMessage	P	@Sender	nvarchar	250	IN
AddEventMessage	P	@Subscriber	nvarchar	100	IN
AddEventMessage	P	@AuthorizedRoles	nvarchar	250	IN
AddEventMessage	P	@ExceptionMessage	nvarchar	250	IN
AddEventMessage	P	@SentDate	datetime	8	IN
AddEventMessage	P	@ExpirationDate	datetime	8	IN
AddEventMessage	P	@Attributes	ntext	1073741823	IN
AddFile	P	@PortalId	int	4	IN
AddFile	P	@UniqueId	uniqueidentifier	16	IN
AddFile	P	@VersionGuid	uniqueidentifier	16	IN
AddFile	P	@FileName	nvarchar	100	IN
AddFile	P	@Extension	nvarchar	100	IN
AddFile	P	@Size	int	4	IN
AddFile	P	@Width	int	4	IN
AddFile	P	@Height	int	4	IN
AddFile	P	@ContentType	nvarchar	200	IN
AddFile	P	@Folder	nvarchar	200	IN
AddFile	P	@FolderID	int	4	IN
AddFile	P	@CreatedByUserID	int	4	IN
AddFile	P	@Hash	varchar	40	IN
AddFolder	P	@PortalID	int	4	IN
AddFolder	P	@UniqueId	uniqueidentifier	16	IN
AddFolder	P	@VersionGuid	uniqueidentifier	16	IN
AddFolder	P	@FolderPath	varchar	300	IN
AddFolder	P	@StorageLocation	int	4	IN
AddFolder	P	@IsProtected	bit	0	IN
AddFolder	P	@IsCached	bit	0	IN
AddFolder	P	@LastUpdated	datetime	8	IN
AddFolder	P	@CreatedByUserID	int	4	IN
AddFolderPermission	P	@FolderID	int	4	IN
AddFolderPermission	P	@PermissionID	int	4	IN
AddFolderPermission	P	@RoleID	int	4	IN
AddFolderPermission	P	@AllowAccess	bit	0	IN
AddFolderPermission	P	@UserID	int	4	IN
AddFolderPermission	P	@CreatedByUserID	int	4	IN
AddHeirarchicalTerm	P	@VocabularyID	int	4	IN
AddHeirarchicalTerm	P	@ParentTermID	int	4	IN
AddHeirarchicalTerm	P	@Name	nvarchar	250	IN
AddHeirarchicalTerm	P	@Description	nvarchar	2500	IN
AddHeirarchicalTerm	P	@Weight	int	4	IN
AddHeirarchicalTerm	P	@CreatedByUserID	int	4	IN
AddHostSetting	P	@SettingName	nvarchar	50	IN
AddHostSetting	P	@SettingValue	nvarchar	256	IN
AddHostSetting	P	@SettingIsSecure	bit	0	IN
AddHostSetting	P	@CreatedByUserID	int	4	IN
AddHtmlText	P	@ModuleID	int	4	IN
AddHtmlText	P	@Content	ntext	1073741823	IN
AddHtmlText	P	@StateID	int	4	IN
AddHtmlText	P	@IsPublished	bit	0	IN
AddHtmlText	P	@UserID	int	4	IN
AddHtmlText	P	@History	int	4	IN
AddHtmlTextLog	P	@ItemID	int	4	IN
AddHtmlTextLog	P	@StateID	int	4	IN
AddHtmlTextLog	P	@Comment	nvarchar	4000	IN
AddHtmlTextLog	P	@Approved	bit	0	IN
AddHtmlTextLog	P	@UserID	int	4	IN
AddHtmlTextUser	P	@ItemID	int	4	IN
AddHtmlTextUser	P	@StateID	int	4	IN
AddHtmlTextUser	P	@ModuleID	int	4	IN
AddHtmlTextUser	P	@TabID	int	4	IN
AddHtmlTextUser	P	@UserID	int	4	IN
AddLanguage	P	@CultureCode	nvarchar	50	IN
AddLanguage	P	@CultureName	nvarchar	200	IN
AddLanguage	P	@FallbackCulture	nvarchar	50	IN
AddLanguage	P	@CreatedByUserID	int	4	IN
AddLanguagePack	P	@PackageID	int	4	IN
AddLanguagePack	P	@LanguageID	int	4	IN
AddLanguagePack	P	@DependentPackageID	int	4	IN
AddLanguagePack	P	@CreatedByUserID	int	4	IN
AddListEntry	P	@ListName	nvarchar	50	IN
AddListEntry	P	@Value	nvarchar	100	IN
AddListEntry	P	@Text	nvarchar	150	IN
AddListEntry	P	@ParentID	int	4	IN
AddListEntry	P	@Level	int	4	IN
AddListEntry	P	@EnableSortOrder	bit	0	IN
AddListEntry	P	@DefinitionID	int	4	IN
AddListEntry	P	@Description	nvarchar	500	IN
AddListEntry	P	@PortalID	int	4	IN
AddListEntry	P	@SystemList	bit	0	IN
AddListEntry	P	@CreatedByUserID	int	4	IN
AddMetaData	P	@ContentItemID	int	4	IN
AddMetaData	P	@Name	nvarchar	100	IN
AddMetaData	P	@Value	nvarchar	-1	IN
AddModule	P	@ContentItemID	int	4	IN
AddModule	P	@PortalID	int	4	IN
AddModule	P	@ModuleDefId	int	4	IN
AddModule	P	@AllTabs	bit	0	IN
AddModule	P	@StartDate	datetime	8	IN
AddModule	P	@EndDate	datetime	8	IN
AddModule	P	@InheritViewPermissions	bit	0	IN
AddModule	P	@IsDeleted	bit	0	IN
AddModule	P	@CreatedByUserID	int	4	IN
AddModuleControl	P	@ModuleDefID	int	4	IN
AddModuleControl	P	@ControlKey	nvarchar	50	IN
AddModuleControl	P	@ControlTitle	nvarchar	50	IN
AddModuleControl	P	@ControlSrc	nvarchar	256	IN
AddModuleControl	P	@IconFile	nvarchar	100	IN
AddModuleControl	P	@ControlType	int	4	IN
AddModuleControl	P	@ViewOrder	int	4	IN
AddModuleControl	P	@HelpUrl	nvarchar	200	IN
AddModuleControl	P	@SupportsPartialRendering	bit	0	IN
AddModuleControl	P	@CreatedByUserID	int	4	IN
AddModuleDefinition	P	@DesktopModuleId	int	4	IN
AddModuleDefinition	P	@FriendlyName	nvarchar	128	IN
AddModuleDefinition	P	@DefaultCacheTime	int	4	IN
AddModuleDefinition	P	@CreatedByUserID	int	4	IN
AddModulePermission	P	@ModuleID	int	4	IN
AddModulePermission	P	@PermissionID	int	4	IN
AddModulePermission	P	@RoleID	int	4	IN
AddModulePermission	P	@AllowAccess	bit	0	IN
AddModulePermission	P	@UserID	int	4	IN
AddModulePermission	P	@CreatedByUserID	int	4	IN
AddModuleSetting	P	@ModuleId	int	4	IN
AddModuleSetting	P	@SettingName	nvarchar	50	IN
AddModuleSetting	P	@SettingValue	nvarchar	2000	IN
AddModuleSetting	P	@CreatedByUserID	int	4	IN
AddPackage	P	@PortalID	int	4	IN
AddPackage	P	@Name	nvarchar	128	IN
AddPackage	P	@FriendlyName	nvarchar	250	IN
AddPackage	P	@Description	nvarchar	2000	IN
AddPackage	P	@PackageType	nvarchar	50	IN
AddPackage	P	@Version	nvarchar	50	IN
AddPackage	P	@License	ntext	1073741823	IN
AddPackage	P	@Manifest	ntext	1073741823	IN
AddPackage	P	@Owner	nvarchar	100	IN
AddPackage	P	@Organization	nvarchar	100	IN
AddPackage	P	@Url	nvarchar	250	IN
AddPackage	P	@Email	nvarchar	100	IN
AddPackage	P	@ReleaseNotes	ntext	1073741823	IN
AddPackage	P	@IsSystemPackage	bit	0	IN
AddPackage	P	@CreatedByUserID	int	4	IN
AddPermission	P	@ModuleDefID	int	4	IN
AddPermission	P	@PermissionCode	varchar	50	IN
AddPermission	P	@PermissionKey	varchar	50	IN
AddPermission	P	@PermissionName	varchar	50	IN
AddPermission	P	@CreatedByUserID	int	4	IN
AddPortalAlias	P	@PortalID	int	4	IN
AddPortalAlias	P	@HTTPAlias	nvarchar	200	IN
AddPortalAlias	P	@CreatedByUserID	int	4	IN
AddPortalDesktopModule	P	@PortalID	int	4	IN
AddPortalDesktopModule	P	@DesktopModuleId	int	4	IN
AddPortalDesktopModule	P	@CreatedByUserID	int	4	IN
AddPortalInfo	P	@PortalName	nvarchar	128	IN
AddPortalInfo	P	@Currency	char	3	IN
AddPortalInfo	P	@ExpiryDate	datetime	8	IN
AddPortalInfo	P	@HostFee	money	8	IN
AddPortalInfo	P	@HostSpace	int	4	IN
AddPortalInfo	P	@PageQuota	int	4	IN
AddPortalInfo	P	@UserQuota	int	4	IN
AddPortalInfo	P	@SiteLogHistory	int	4	IN
AddPortalInfo	P	@HomeDirectory	varchar	100	IN
AddPortalInfo	P	@CreatedByUserID	int	4	IN
AddPortalLanguage	P	@PortalId	int	4	IN
AddPortalLanguage	P	@LanguageId	int	4	IN
AddPortalLanguage	P	@IsPublished	bit	0	IN
AddPortalLanguage	P	@CreatedByUserID	int	4	IN
AddProfile	P	@UserID	int	4	IN
AddProfile	P	@PortalID	int	4	IN
AddPropertyDefinition	P	@PortalId	int	4	IN
AddPropertyDefinition	P	@ModuleDefId	int	4	IN
AddPropertyDefinition	P	@DataType	int	4	IN
AddPropertyDefinition	P	@DefaultValue	ntext	1073741823	IN
AddPropertyDefinition	P	@PropertyCategory	nvarchar	50	IN
AddPropertyDefinition	P	@PropertyName	nvarchar	50	IN
AddPropertyDefinition	P	@Required	bit	0	IN
AddPropertyDefinition	P	@ValidationExpression	nvarchar	2000	IN
AddPropertyDefinition	P	@ViewOrder	int	4	IN
AddPropertyDefinition	P	@Visible	bit	0	IN
AddPropertyDefinition	P	@Length	int	4	IN
AddPropertyDefinition	P	@DefaultVisibility	int	4	IN
AddPropertyDefinition	P	@CreatedByUserID	int	4	IN
AddRole	P	@PortalID	int	4	IN
AddRole	P	@RoleGroupId	int	4	IN
AddRole	P	@RoleName	nvarchar	50	IN
AddRole	P	@Description	nvarchar	1000	IN
AddRole	P	@ServiceFee	money	8	IN
AddRole	P	@BillingPeriod	int	4	IN
AddRole	P	@BillingFrequency	char	1	IN
AddRole	P	@TrialFee	money	8	IN
AddRole	P	@TrialPeriod	int	4	IN
AddRole	P	@TrialFrequency	char	1	IN
AddRole	P	@IsPublic	bit	0	IN
AddRole	P	@AutoAssignment	bit	0	IN
AddRole	P	@RSVPCode	nvarchar	50	IN
AddRole	P	@IconFile	nvarchar	100	IN
AddRole	P	@CreatedByUserID	int	4	IN
AddRoleGroup	P	@PortalID	int	4	IN
AddRoleGroup	P	@RoleGroupName	nvarchar	50	IN
AddRoleGroup	P	@Description	nvarchar	1000	IN
AddRoleGroup	P	@CreatedByUserID	int	4	IN
AddSchedule	P	@TypeFullName	varchar	200	IN
AddSchedule	P	@TimeLapse	int	4	IN
AddSchedule	P	@TimeLapseMeasurement	varchar	2	IN
AddSchedule	P	@RetryTimeLapse	int	4	IN
AddSchedule	P	@RetryTimeLapseMeasurement	varchar	2	IN
AddSchedule	P	@RetainHistoryNum	int	4	IN
AddSchedule	P	@AttachToEvent	varchar	50	IN
AddSchedule	P	@CatchUpEnabled	bit	0	IN
AddSchedule	P	@Enabled	bit	0	IN
AddSchedule	P	@ObjectDependencies	varchar	300	IN
AddSchedule	P	@Servers	varchar	150	IN
AddSchedule	P	@CreatedByUserID	int	4	IN
AddSchedule	P	@FriendlyName	varchar	200	IN
AddScheduleHistory	P	@ScheduleID	int	4	IN
AddScheduleHistory	P	@StartDate	datetime	8	IN
AddScheduleHistory	P	@Server	varchar	150	IN
AddScheduleItemSetting	P	@ScheduleID	int	4	IN
AddScheduleItemSetting	P	@Name	nvarchar	50	IN
AddScheduleItemSetting	P	@Value	nvarchar	256	IN
AddScopeType	P	@ScopeType	nvarchar	250	IN
AddSearchCommonWord	P	@CommonWord	nvarchar	255	IN
AddSearchCommonWord	P	@Locale	nvarchar	10	IN
AddSearchItem	P	@Title	nvarchar	200	IN
AddSearchItem	P	@Description	nvarchar	2000	IN
AddSearchItem	P	@Author	int	4	IN
AddSearchItem	P	@PubDate	datetime	8	IN
AddSearchItem	P	@ModuleId	int	4	IN
AddSearchItem	P	@SearchKey	nvarchar	100	IN
AddSearchItem	P	@Guid	nvarchar	200	IN
AddSearchItem	P	@ImageFileId	int	4	IN
AddSearchItemWord	P	@SearchItemID	int	4	IN
AddSearchItemWord	P	@SearchWordsID	int	4	IN
AddSearchItemWord	P	@Occurrences	int	4	IN
AddSearchItemWordPosition	P	@SearchItemWordID	int	4	IN
AddSearchItemWordPosition	P	@ContentPositions	varchar	2000	IN
AddSearchWord	P	@Word	nvarchar	100	IN
AddSimpleTerm	P	@VocabularyID	int	4	IN
AddSimpleTerm	P	@Name	nvarchar	250	IN
AddSimpleTerm	P	@Description	nvarchar	2500	IN
AddSimpleTerm	P	@Weight	int	4	IN
AddSimpleTerm	P	@CreatedByUserID	int	4	IN
AddSiteLog	P	@DateTime	datetime	8	IN
AddSiteLog	P	@PortalID	int	4	IN
AddSiteLog	P	@UserID	int	4	IN
AddSiteLog	P	@Referrer	nvarchar	255	IN
AddSiteLog	P	@Url	nvarchar	255	IN
AddSiteLog	P	@UserAgent	nvarchar	255	IN
AddSiteLog	P	@UserHostAddress	nvarchar	255	IN
AddSiteLog	P	@UserHostName	nvarchar	255	IN
AddSiteLog	P	@TabId	int	4	IN
AddSiteLog	P	@AffiliateId	int	4	IN
AddSkin	P	@SkinPackageID	int	4	IN
AddSkin	P	@SkinSrc	nvarchar	200	IN
AddSkinControl	P	@PackageID	int	4	IN
AddSkinControl	P	@ControlKey	nvarchar	50	IN
AddSkinControl	P	@ControlSrc	nvarchar	256	IN
AddSkinControl	P	@SupportsPartialRendering	bit	0	IN
AddSkinControl	P	@CreatedByUserID	int	4	IN
AddSkinPackage	P	@PackageID	int	4	IN
AddSkinPackage	P	@PortalID	int	4	IN
AddSkinPackage	P	@SkinName	nvarchar	50	IN
AddSkinPackage	P	@SkinType	nvarchar	20	IN
AddSkinPackage	P	@CreatedByUserID	int	4	IN
AddSystemMessage	P	@PortalID	int	4	IN
AddSystemMessage	P	@MessageName	nvarchar	50	IN
AddSystemMessage	P	@MessageValue	ntext	1073741823	IN
AddTab	P	@ContentItemID	int	4	IN
AddTab	P	@PortalID	int	4	IN
AddTab	P	@UniqueId	uniqueidentifier	16	IN
AddTab	P	@VersionGuid	uniqueidentifier	16	IN
AddTab	P	@DefaultLanguageGuid	uniqueidentifier	16	IN
AddTab	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
AddTab	P	@TabName	nvarchar	50	IN
AddTab	P	@IsVisible	bit	0	IN
AddTab	P	@DisableLink	bit	0	IN
AddTab	P	@ParentId	int	4	IN
AddTab	P	@IconFile	nvarchar	100	IN
AddTab	P	@IconFileLarge	nvarchar	100	IN
AddTab	P	@Title	nvarchar	200	IN
AddTab	P	@Description	nvarchar	500	IN
AddTab	P	@KeyWords	nvarchar	500	IN
AddTab	P	@Url	nvarchar	255	IN
AddTab	P	@SkinSrc	nvarchar	200	IN
AddTab	P	@ContainerSrc	nvarchar	200	IN
AddTab	P	@TabPath	nvarchar	255	IN
AddTab	P	@StartDate	datetime	8	IN
AddTab	P	@EndDate	datetime	8	IN
AddTab	P	@RefreshInterval	int	4	IN
AddTab	P	@PageHeadText	nvarchar	500	IN
AddTab	P	@IsSecure	bit	0	IN
AddTab	P	@PermanentRedirect	bit	0	IN
AddTab	P	@SiteMapPriority	float	4	IN
AddTab	P	@CreatedByUserID	int	4	IN
AddTab	P	@CultureCode	nvarchar	50	IN
AddTabModule	P	@TabId	int	4	IN
AddTabModule	P	@ModuleId	int	4	IN
AddTabModule	P	@ModuleTitle	nvarchar	256	IN
AddTabModule	P	@Header	ntext	1073741823	IN
AddTabModule	P	@Footer	ntext	1073741823	IN
AddTabModule	P	@ModuleOrder	int	4	IN
AddTabModule	P	@PaneName	nvarchar	50	IN
AddTabModule	P	@CacheTime	int	4	IN
AddTabModule	P	@CacheMethod	varchar	50	IN
AddTabModule	P	@Alignment	nvarchar	10	IN
AddTabModule	P	@Color	nvarchar	20	IN
AddTabModule	P	@Border	nvarchar	1	IN
AddTabModule	P	@IconFile	nvarchar	100	IN
AddTabModule	P	@Visibility	int	4	IN
AddTabModule	P	@ContainerSrc	nvarchar	200	IN
AddTabModule	P	@DisplayTitle	bit	0	IN
AddTabModule	P	@DisplayPrint	bit	0	IN
AddTabModule	P	@DisplaySyndicate	bit	0	IN
AddTabModule	P	@IsWebSlice	bit	0	IN
AddTabModule	P	@WebSliceTitle	nvarchar	256	IN
AddTabModule	P	@WebSliceExpiryDate	datetime	8	IN
AddTabModule	P	@WebSliceTTL	int	4	IN
AddTabModule	P	@UniqueId	uniqueidentifier	16	IN
AddTabModule	P	@VersionGuid	uniqueidentifier	16	IN
AddTabModule	P	@DefaultLanguageGuid	uniqueidentifier	16	IN
AddTabModule	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
AddTabModule	P	@CultureCode	nvarchar	10	IN
AddTabModule	P	@CreatedByUserID	int	4	IN
AddTabModuleSetting	P	@TabModuleId	int	4	IN
AddTabModuleSetting	P	@SettingName	nvarchar	50	IN
AddTabModuleSetting	P	@SettingValue	nvarchar	2000	IN
AddTabModuleSetting	P	@CreatedByUserID	int	4	IN
AddTabPermission	P	@TabID	int	4	IN
AddTabPermission	P	@PermissionID	int	4	IN
AddTabPermission	P	@RoleID	int	4	IN
AddTabPermission	P	@AllowAccess	bit	0	IN
AddTabPermission	P	@UserID	int	4	IN
AddTabPermission	P	@CreatedByUserID	int	4	IN
AddTabSetting	P	@TabID	int	4	IN
AddTabSetting	P	@SettingName	nvarchar	50	IN
AddTabSetting	P	@SettingValue	nvarchar	2000	IN
AddTabSetting	P	@CreatedByUserID	int	4	IN
AddTermToContent	P	@TermID	int	4	IN
AddTermToContent	P	@ContentItemID	int	4	IN
AddUrl	P	@PortalID	int	4	IN
AddUrl	P	@Url	nvarchar	255	IN
AddUrlLog	P	@UrlTrackingID	int	4	IN
AddUrlLog	P	@UserID	int	4	IN
AddUrlTracking	P	@PortalID	int	4	IN
AddUrlTracking	P	@Url	nvarchar	255	IN
AddUrlTracking	P	@UrlType	char	1	IN
AddUrlTracking	P	@LogActivity	bit	0	IN
AddUrlTracking	P	@TrackClicks	bit	0	IN
AddUrlTracking	P	@ModuleId	int	4	IN
AddUrlTracking	P	@NewWindow	bit	0	IN
AddUser	P	@PortalID	int	4	IN
AddUser	P	@Username	nvarchar	100	IN
AddUser	P	@FirstName	nvarchar	50	IN
AddUser	P	@LastName	nvarchar	50	IN
AddUser	P	@AffiliateId	int	4	IN
AddUser	P	@IsSuperUser	bit	0	IN
AddUser	P	@Email	nvarchar	256	IN
AddUser	P	@DisplayName	nvarchar	100	IN
AddUser	P	@UpdatePassword	bit	0	IN
AddUser	P	@Authorised	bit	0	IN
AddUser	P	@CreatedByUserID	int	4	IN
AddUserAuthentication	P	@UserID	int	4	IN
AddUserAuthentication	P	@AuthenticationType	nvarchar	100	IN
AddUserAuthentication	P	@AuthenticationToken	nvarchar	1000	IN
AddUserAuthentication	P	@CreatedByUserID	int	4	IN
AddUserRole	P	@PortalID	int	4	IN
AddUserRole	P	@UserID	int	4	IN
AddUserRole	P	@RoleId	int	4	IN
AddUserRole	P	@EffectiveDate	datetime	8	IN
AddUserRole	P	@ExpiryDate	datetime	8	IN
AddUserRole	P	@CreatedByUserID	int	4	IN
AddVendor	P	@PortalID	int	4	IN
AddVendor	P	@VendorName	nvarchar	50	IN
AddVendor	P	@Unit	nvarchar	50	IN
AddVendor	P	@Street	nvarchar	50	IN
AddVendor	P	@City	nvarchar	50	IN
AddVendor	P	@Region	nvarchar	50	IN
AddVendor	P	@Country	nvarchar	50	IN
AddVendor	P	@PostalCode	nvarchar	50	IN
AddVendor	P	@Telephone	nvarchar	50	IN
AddVendor	P	@Fax	nvarchar	50	IN
AddVendor	P	@Cell	nvarchar	50	IN
AddVendor	P	@Email	nvarchar	50	IN
AddVendor	P	@Website	nvarchar	100	IN
AddVendor	P	@FirstName	nvarchar	50	IN
AddVendor	P	@LastName	nvarchar	50	IN
AddVendor	P	@UserName	nvarchar	100	IN
AddVendor	P	@LogoFile	nvarchar	100	IN
AddVendor	P	@KeyWords	text		IN
AddVendor	P	@Authorized	bit	0	IN
AddVendorClassification	P	@VendorId	int	4	IN
AddVendorClassification	P	@ClassificationId	int	4	IN
AddVocabulary	P	@VocabularyTypeID	int	4	IN
AddVocabulary	P	@Name	nvarchar	250	IN
AddVocabulary	P	@Description	nvarchar	2500	IN
AddVocabulary	P	@Weight	int	4	IN
AddVocabulary	P	@ScopeID	int	4	IN
AddVocabulary	P	@ScopeTypeID	int	4	IN
AddVocabulary	P	@CreatedByUserID	int	4	IN
aspnet_AnyDataInTables	P	@TablesToCheck	int	4	IN
aspnet_Applications_CreateApplication	P	@ApplicationName	nvarchar	256	IN
aspnet_Applications_CreateApplication	P	@ApplicationId	uniqueidentifier	16	INOUT
aspnet_CheckSchemaVersion	P	@Feature	nvarchar	128	IN
aspnet_CheckSchemaVersion	P	@CompatibleSchemaVersion	nvarchar	128	IN
aspnet_Membership_ChangePasswordQuestionAndAnswer	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_ChangePasswordQuestionAndAnswer	P	@UserName	nvarchar	256	IN
aspnet_Membership_ChangePasswordQuestionAndAnswer	P	@NewPasswordQuestion	nvarchar	256	IN
aspnet_Membership_ChangePasswordQuestionAndAnswer	P	@NewPasswordAnswer	nvarchar	128	IN
aspnet_Membership_CreateUser	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_CreateUser	P	@UserName	nvarchar	256	IN
aspnet_Membership_CreateUser	P	@Password	nvarchar	128	IN
aspnet_Membership_CreateUser	P	@PasswordSalt	nvarchar	128	IN
aspnet_Membership_CreateUser	P	@Email	nvarchar	256	IN
aspnet_Membership_CreateUser	P	@PasswordQuestion	nvarchar	256	IN
aspnet_Membership_CreateUser	P	@PasswordAnswer	nvarchar	128	IN
aspnet_Membership_CreateUser	P	@IsApproved	bit	0	IN
aspnet_Membership_CreateUser	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_CreateUser	P	@CreateDate	datetime	8	IN
aspnet_Membership_CreateUser	P	@UniqueEmail	int	4	IN
aspnet_Membership_CreateUser	P	@PasswordFormat	int	4	IN
aspnet_Membership_CreateUser	P	@UserId	uniqueidentifier	16	INOUT
aspnet_Membership_FindUsersByEmail	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_FindUsersByEmail	P	@EmailToMatch	nvarchar	256	IN
aspnet_Membership_FindUsersByEmail	P	@PageIndex	int	4	IN
aspnet_Membership_FindUsersByEmail	P	@PageSize	int	4	IN
aspnet_Membership_FindUsersByName	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_FindUsersByName	P	@UserNameToMatch	nvarchar	256	IN
aspnet_Membership_FindUsersByName	P	@PageIndex	int	4	IN
aspnet_Membership_FindUsersByName	P	@PageSize	int	4	IN
aspnet_Membership_GetAllUsers	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetAllUsers	P	@PageIndex	int	4	IN
aspnet_Membership_GetAllUsers	P	@PageSize	int	4	IN
aspnet_Membership_GetNumberOfUsersOnline	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetNumberOfUsersOnline	P	@MinutesSinceLastInActive	int	4	IN
aspnet_Membership_GetNumberOfUsersOnline	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_GetPassword	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetPassword	P	@UserName	nvarchar	256	IN
aspnet_Membership_GetPassword	P	@MaxInvalidPasswordAttempts	int	4	IN
aspnet_Membership_GetPassword	P	@PasswordAttemptWindow	int	4	IN
aspnet_Membership_GetPassword	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_GetPassword	P	@PasswordAnswer	nvarchar	128	IN
aspnet_Membership_GetPasswordWithFormat	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetPasswordWithFormat	P	@UserName	nvarchar	256	IN
aspnet_Membership_GetPasswordWithFormat	P	@UpdateLastLoginActivityDate	bit	0	IN
aspnet_Membership_GetPasswordWithFormat	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_GetUserByEmail	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetUserByEmail	P	@Email	nvarchar	256	IN
aspnet_Membership_GetUserByName	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_GetUserByName	P	@UserName	nvarchar	256	IN
aspnet_Membership_GetUserByName	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_GetUserByName	P	@UpdateLastActivity	bit	0	IN
aspnet_Membership_GetUserByUserId	P	@UserId	uniqueidentifier	16	IN
aspnet_Membership_GetUserByUserId	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_GetUserByUserId	P	@UpdateLastActivity	bit	0	IN
aspnet_Membership_ResetPassword	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_ResetPassword	P	@UserName	nvarchar	256	IN
aspnet_Membership_ResetPassword	P	@NewPassword	nvarchar	128	IN
aspnet_Membership_ResetPassword	P	@MaxInvalidPasswordAttempts	int	4	IN
aspnet_Membership_ResetPassword	P	@PasswordAttemptWindow	int	4	IN
aspnet_Membership_ResetPassword	P	@PasswordSalt	nvarchar	128	IN
aspnet_Membership_ResetPassword	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_ResetPassword	P	@PasswordFormat	int	4	IN
aspnet_Membership_ResetPassword	P	@PasswordAnswer	nvarchar	128	IN
aspnet_Membership_SetPassword	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_SetPassword	P	@UserName	nvarchar	256	IN
aspnet_Membership_SetPassword	P	@NewPassword	nvarchar	128	IN
aspnet_Membership_SetPassword	P	@PasswordSalt	nvarchar	128	IN
aspnet_Membership_SetPassword	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_SetPassword	P	@PasswordFormat	int	4	IN
aspnet_Membership_UnlockUser	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_UnlockUser	P	@UserName	nvarchar	256	IN
aspnet_Membership_UpdateUser	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_UpdateUser	P	@UserName	nvarchar	256	IN
aspnet_Membership_UpdateUser	P	@Email	nvarchar	256	IN
aspnet_Membership_UpdateUser	P	@Comment	ntext	1073741823	IN
aspnet_Membership_UpdateUser	P	@IsApproved	bit	0	IN
aspnet_Membership_UpdateUser	P	@LastLoginDate	datetime	8	IN
aspnet_Membership_UpdateUser	P	@LastActivityDate	datetime	8	IN
aspnet_Membership_UpdateUser	P	@UniqueEmail	int	4	IN
aspnet_Membership_UpdateUser	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_UpdateUserInfo	P	@ApplicationName	nvarchar	256	IN
aspnet_Membership_UpdateUserInfo	P	@UserName	nvarchar	256	IN
aspnet_Membership_UpdateUserInfo	P	@IsPasswordCorrect	bit	0	IN
aspnet_Membership_UpdateUserInfo	P	@UpdateLastLoginActivityDate	bit	0	IN
aspnet_Membership_UpdateUserInfo	P	@MaxInvalidPasswordAttempts	int	4	IN
aspnet_Membership_UpdateUserInfo	P	@PasswordAttemptWindow	int	4	IN
aspnet_Membership_UpdateUserInfo	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Membership_UpdateUserInfo	P	@LastLoginDate	datetime	8	IN
aspnet_Membership_UpdateUserInfo	P	@LastActivityDate	datetime	8	IN
aspnet_Profile_DeleteInactiveProfiles	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_DeleteInactiveProfiles	P	@ProfileAuthOptions	int	4	IN
aspnet_Profile_DeleteInactiveProfiles	P	@InactiveSinceDate	datetime	8	IN
aspnet_Profile_DeleteProfiles	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_DeleteProfiles	P	@UserNames	nvarchar	4000	IN
aspnet_Profile_GetNumberOfInactiveProfiles	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_GetNumberOfInactiveProfiles	P	@ProfileAuthOptions	int	4	IN
aspnet_Profile_GetNumberOfInactiveProfiles	P	@InactiveSinceDate	datetime	8	IN
aspnet_Profile_GetProfiles	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_GetProfiles	P	@ProfileAuthOptions	int	4	IN
aspnet_Profile_GetProfiles	P	@PageIndex	int	4	IN
aspnet_Profile_GetProfiles	P	@PageSize	int	4	IN
aspnet_Profile_GetProfiles	P	@UserNameToMatch	nvarchar	256	IN
aspnet_Profile_GetProfiles	P	@InactiveSinceDate	datetime	8	IN
aspnet_Profile_GetProperties	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_GetProperties	P	@UserName	nvarchar	256	IN
aspnet_Profile_GetProperties	P	@CurrentTimeUtc	datetime	8	IN
aspnet_Profile_SetProperties	P	@ApplicationName	nvarchar	256	IN
aspnet_Profile_SetProperties	P	@PropertyNames	ntext	1073741823	IN
aspnet_Profile_SetProperties	P	@PropertyValuesString	ntext	1073741823	IN
aspnet_Profile_SetProperties	P	@PropertyValuesBinary	image		IN
aspnet_Profile_SetProperties	P	@UserName	nvarchar	256	IN
aspnet_Profile_SetProperties	P	@IsUserAnonymous	bit	0	IN
aspnet_Profile_SetProperties	P	@CurrentTimeUtc	datetime	8	IN
aspnet_RegisterSchemaVersion	P	@Feature	nvarchar	128	IN
aspnet_RegisterSchemaVersion	P	@CompatibleSchemaVersion	nvarchar	128	IN
aspnet_RegisterSchemaVersion	P	@IsCurrentVersion	bit	0	IN
aspnet_RegisterSchemaVersion	P	@RemoveIncompatibleSchema	bit	0	IN
aspnet_Roles_CreateRole	P	@ApplicationName	nvarchar	256	IN
aspnet_Roles_CreateRole	P	@RoleName	nvarchar	256	IN
aspnet_Roles_DeleteRole	P	@ApplicationName	nvarchar	256	IN
aspnet_Roles_DeleteRole	P	@RoleName	nvarchar	256	IN
aspnet_Roles_DeleteRole	P	@DeleteOnlyIfRoleIsEmpty	bit	0	IN
aspnet_Roles_GetAllRoles	P	@ApplicationName	nvarchar	256	IN
aspnet_Roles_RoleExists	P	@ApplicationName	nvarchar	256	IN
aspnet_Roles_RoleExists	P	@RoleName	nvarchar	256	IN
aspnet_Setup_RemoveAllRoleMembers	P	@name	nvarchar	128	IN
aspnet_Setup_RestorePermissions	P	@name	nvarchar	128	IN
aspnet_UnRegisterSchemaVersion	P	@Feature	nvarchar	128	IN
aspnet_UnRegisterSchemaVersion	P	@CompatibleSchemaVersion	nvarchar	128	IN
aspnet_Users_CreateUser	P	@ApplicationId	uniqueidentifier	16	IN
aspnet_Users_CreateUser	P	@UserName	nvarchar	256	IN
aspnet_Users_CreateUser	P	@IsUserAnonymous	bit	0	IN
aspnet_Users_CreateUser	P	@LastActivityDate	datetime	8	IN
aspnet_Users_CreateUser	P	@UserId	uniqueidentifier	16	INOUT
aspnet_Users_DeleteUser	P	@ApplicationName	nvarchar	256	IN
aspnet_Users_DeleteUser	P	@UserName	nvarchar	256	IN
aspnet_Users_DeleteUser	P	@TablesToDeleteFrom	int	4	IN
aspnet_Users_DeleteUser	P	@NumTablesDeletedFrom	int	4	INOUT
aspnet_UsersInRoles_AddUsersToRoles	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_AddUsersToRoles	P	@UserNames	nvarchar	4000	IN
aspnet_UsersInRoles_AddUsersToRoles	P	@RoleNames	nvarchar	4000	IN
aspnet_UsersInRoles_AddUsersToRoles	P	@CurrentTimeUtc	datetime	8	IN
aspnet_UsersInRoles_FindUsersInRole	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_FindUsersInRole	P	@RoleName	nvarchar	256	IN
aspnet_UsersInRoles_FindUsersInRole	P	@UserNameToMatch	nvarchar	256	IN
aspnet_UsersInRoles_GetRolesForUser	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_GetRolesForUser	P	@UserName	nvarchar	256	IN
aspnet_UsersInRoles_GetUsersInRoles	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_GetUsersInRoles	P	@RoleName	nvarchar	256	IN
aspnet_UsersInRoles_IsUserInRole	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_IsUserInRole	P	@UserName	nvarchar	256	IN
aspnet_UsersInRoles_IsUserInRole	P	@RoleName	nvarchar	256	IN
aspnet_UsersInRoles_RemoveUsersFromRoles	P	@ApplicationName	nvarchar	256	IN
aspnet_UsersInRoles_RemoveUsersFromRoles	P	@UserNames	nvarchar	4000	IN
aspnet_UsersInRoles_RemoveUsersFromRoles	P	@RoleNames	nvarchar	4000	IN
CalculatePagingInformation	P	@pageIndex	int	4	IN
CalculatePagingInformation	P	@pageSize	int	4	IN
CalculatePagingInformation	P	@rowsToReturn	int	4	INOUT
CalculatePagingInformation	P	@pageLowerBound	int	4	INOUT
CalculatePagingInformation	P	@pageUpperBound	int	4	INOUT
CanDeleteSkin	P	@SkinType	char	1	IN
CanDeleteSkin	P	@SkinFolderName	nvarchar	200	IN
Dashboard_AddControl	P	@PackageId	int	4	IN
Dashboard_AddControl	P	@DashboardControlKey	nvarchar	50	IN
Dashboard_AddControl	P	@IsEnabled	bit	0	IN
Dashboard_AddControl	P	@DashboardControlSrc	nvarchar	250	IN
Dashboard_AddControl	P	@DashboardControlLocalResources	nvarchar	250	IN
Dashboard_AddControl	P	@ControllerClass	nvarchar	250	IN
Dashboard_AddControl	P	@ViewOrder	int	4	IN
Dashboard_DeleteControl	P	@DashboardControlID	int	4	IN
Dashboard_GetControls	P	@IsEnabled	bit	0	IN
Dashboard_GetDashboardControlByKey	P	@DashboardControlKey	nvarchar	50	IN
Dashboard_UpdateControl	P	@DashboardControlID	int	4	IN
Dashboard_UpdateControl	P	@DashboardControlKey	nvarchar	50	IN
Dashboard_UpdateControl	P	@IsEnabled	bit	0	IN
Dashboard_UpdateControl	P	@DashboardControlSrc	nvarchar	250	IN
Dashboard_UpdateControl	P	@DashboardControlLocalResources	nvarchar	250	IN
Dashboard_UpdateControl	P	@ControllerClass	nvarchar	250	IN
Dashboard_UpdateControl	P	@ViewOrder	int	4	IN
DeleteAffiliate	P	@AffiliateId	int	4	IN
DeleteAuthentication	P	@AuthenticationID	int	4	IN
DeleteBanner	P	@BannerId	int	4	IN
DeleteContentItem	P	@ContentItemId	int	4	IN
DeleteContentType	P	@ContentTypeId	int	4	IN
DeleteDesktopModule	P	@DesktopModuleId	int	4	IN
DeleteDesktopModulePermission	P	@DesktopModulePermissionID	int	4	IN
DeleteDesktopModulePermissionsByPortalDesktopModuleID	P	@PortalDesktopModuleID	int	4	IN
DeleteDesktopModulePermissionsByUserID	P	@UserID	int	4	IN
DeleteEventLog	P	@LogGUID	varchar	36	IN
DeleteEventLogConfig	P	@ID	int	4	IN
DeleteEventLogType	P	@LogTypeKey	nvarchar	35	IN
DeleteFile	P	@PortalID	int	4	IN
DeleteFile	P	@FileName	nvarchar	100	IN
DeleteFile	P	@FolderID	int	4	IN
DeleteFiles	P	@PortalID	int	4	IN
DeleteFolder	P	@PortalID	int	4	IN
DeleteFolder	P	@FolderPath	varchar	300	IN
DeleteFolderPermission	P	@FolderPermissionID	int	4	IN
DeleteFolderPermissionsByFolderPath	P	@PortalID	int	4	IN
DeleteFolderPermissionsByFolderPath	P	@FolderPath	varchar	300	IN
DeleteFolderPermissionsByUserID	P	@PortalID	int	4	IN
DeleteFolderPermissionsByUserID	P	@UserID	int	4	IN
DeleteHeirarchicalTerm	P	@TermId	int	4	IN
DeleteHtmlText	P	@ModuleID	int	4	IN
DeleteHtmlText	P	@ItemID	int	4	IN
DeleteLanguage	P	@LanguageID	int	4	IN
DeleteLanguagePack	P	@LanguagePackID	int	4	IN
DeleteList	P	@ListName	nvarchar	50	IN
DeleteList	P	@ParentKey	nvarchar	150	IN
DeleteListEntryByID	P	@EntryId	int	4	IN
DeleteListEntryByID	P	@DeleteChild	bit	0	IN
DeleteMetaData	P	@ContentItemId	int	4	IN
DeleteMetaData	P	@Name	nvarchar	100	IN
DeleteMetaData	P	@Value	nvarchar	-1	IN
DeleteModule	P	@ModuleId	int	4	IN
DeleteModuleControl	P	@ModuleControlId	int	4	IN
DeleteModuleDefinition	P	@ModuleDefId	int	4	IN
DeleteModulePermission	P	@ModulePermissionID	int	4	IN
DeleteModulePermissionsByModuleID	P	@ModuleID	int	4	IN
DeleteModulePermissionsByUserID	P	@PortalID	int	4	IN
DeleteModulePermissionsByUserID	P	@UserID	int	4	IN
DeleteModuleSetting	P	@ModuleId	int	4	IN
DeleteModuleSetting	P	@SettingName	nvarchar	50	IN
DeleteModuleSettings	P	@ModuleId	int	4	IN
DeletePackage	P	@PackageID	int	4	IN
DeletePermission	P	@PermissionID	int	4	IN
DeletePortalAlias	P	@PortalAliasID	int	4	IN
DeletePortalDesktopModules	P	@PortalID	int	4	IN
DeletePortalDesktopModules	P	@DesktopModuleId	int	4	IN
DeletePortalInfo	P	@PortalID	int	4	IN
DeletePortalLanguages	P	@PortalId	int	4	IN
DeletePortalLanguages	P	@LanguageId	int	4	IN
DeletePortalSetting	P	@PortalID	int	4	IN
DeletePortalSetting	P	@SettingName	nvarchar	50	IN
DeletePortalSetting	P	@CultureCode	nvarchar	50	IN
DeletePortalSettings	P	@PortalID	int	4	IN
DeletePropertyDefinition	P	@PropertyDefinitionId	int	4	IN
DeleteRole	P	@RoleId	int	4	IN
DeleteRoleGroup	P	@RoleGroupId	int	4	IN
DeleteSchedule	P	@ScheduleID	int	4	IN
DeleteScopeType	P	@ScopeTypeId	int	4	IN
DeleteSearchCommonWord	P	@CommonWordID	int	4	IN
DeleteSearchItem	P	@SearchItemID	int	4	IN
DeleteSearchItems	P	@ModuleID	int	4	IN
DeleteSearchItemWord	P	@SearchItemWordID	int	4	IN
DeleteSearchItemWordPosition	P	@SearchItemWordPositionID	int	4	IN
DeleteSearchItemWords	P	@SearchItemID	int	4	IN
DeleteSearchWord	P	@SearchWordsID	int	4	IN
DeleteServer	P	@ServerID	int	4	IN
DeleteSimpleTerm	P	@TermId	int	4	IN
DeleteSiteLog	P	@DateTime	datetime	8	IN
DeleteSiteLog	P	@PortalID	int	4	IN
DeleteSkin	P	@SkinID	int	4	IN
DeleteSkinControl	P	@SkinControlId	int	4	IN
DeleteSkinPackage	P	@SkinPackageID	int	4	IN
DeleteSystemMessage	P	@PortalID	int	4	IN
DeleteSystemMessage	P	@MessageName	nvarchar	50	IN
DeleteTab	P	@TabId	int	4	IN
DeleteTabModule	P	@TabId	int	4	IN
DeleteTabModule	P	@ModuleId	int	4	IN
DeleteTabModule	P	@SoftDelete	bit	0	IN
DeleteTabModuleSetting	P	@TabModuleId	int	4	IN
DeleteTabModuleSetting	P	@SettingName	nvarchar	50	IN
DeleteTabModuleSettings	P	@TabModuleId	int	4	IN
DeleteTabPermission	P	@TabPermissionID	int	4	IN
DeleteTabPermissionsByTabID	P	@TabID	int	4	IN
DeleteTabPermissionsByUserID	P	@PortalID	int	4	IN
DeleteTabPermissionsByUserID	P	@UserID	int	4	IN
DeleteTabSetting	P	@TabID	int	4	IN
DeleteTabSetting	P	@SettingName	nvarchar	50	IN
DeleteTabSettings	P	@TabID	int	4	IN
DeleteUrl	P	@PortalID	int	4	IN
DeleteUrl	P	@Url	nvarchar	255	IN
DeleteUrlTracking	P	@PortalID	int	4	IN
DeleteUrlTracking	P	@Url	nvarchar	255	IN
DeleteUrlTracking	P	@ModuleID	int	4	IN
DeleteUserPortal	P	@UserID	int	4	IN
DeleteUserPortal	P	@PortalID	int	4	IN
DeleteUserRole	P	@UserID	int	4	IN
DeleteUserRole	P	@RoleId	int	4	IN
DeleteUsersOnline	P	@TimeWindow	int	4	IN
DeleteVendor	P	@VendorId	int	4	IN
DeleteVendorClassifications	P	@VendorId	int	4	IN
DeleteVocabulary	P	@VocabularyID	int	4	IN
dnnLinks_AddLink	P	@ModuleId	int	4	IN
dnnLinks_AddLink	P	@UserId	int	4	IN
dnnLinks_AddLink	P	@CreatedDate	datetime	8	IN
dnnLinks_AddLink	P	@Title	nvarchar	100	IN
dnnLinks_AddLink	P	@Url	nvarchar	250	IN
dnnLinks_AddLink	P	@ViewOrder	int	4	IN
dnnLinks_AddLink	P	@Description	nvarchar	2000	IN
dnnLinks_DeleteLink	P	@ItemId	int	4	IN
dnnLinks_DeleteLink	P	@ModuleId	int	4	IN
dnnLinks_GetLink	P	@ItemId	int	4	IN
dnnLinks_GetLink	P	@ModuleId	int	4	IN
dnnLinks_GetLinks	P	@ModuleId	int	4	IN
dnnLinks_UpdateLink	P	@ItemId	int	4	IN
dnnLinks_UpdateLink	P	@UserId	int	4	IN
dnnLinks_UpdateLink	P	@CreatedDate	datetime	8	IN
dnnLinks_UpdateLink	P	@Title	nvarchar	100	IN
dnnLinks_UpdateLink	P	@Url	nvarchar	250	IN
dnnLinks_UpdateLink	P	@ViewOrder	int	4	IN
dnnLinks_UpdateLink	P	@Description	nvarchar	2000	IN
EnsureLocalizationExists	P	@PortalId	int	4	IN
EnsureLocalizationExists	P	@CultureCode	nvarchar	10	IN
FindBanners	P	@PortalID	int	4	IN
FindBanners	P	@BannerTypeId	int	4	IN
FindBanners	P	@GroupName	nvarchar	100	IN
FindDatabaseVersion	P	@Major	int	4	IN
FindDatabaseVersion	P	@Minor	int	4	IN
FindDatabaseVersion	P	@Build	int	4	IN
GetAffiliate	P	@AffiliateId	int	4	IN
GetAffiliate	P	@VendorId	int	4	IN
GetAffiliate	P	@PortalID	int	4	IN
GetAffiliates	P	@VendorId	int	4	IN
GetAllHtmlText	P	@ModuleID	int	4	IN
GetAllTabsModules	P	@PortalID	int	4	IN
GetAllTabsModules	P	@AllTabs	bit	0	IN
GetAllTabsModulesByModuleID	P	@ModuleID	int	4	IN
GetAllUsers	P	@PortalID	int	4	IN
GetAllUsers	P	@PageIndex	int	4	IN
GetAllUsers	P	@PageSize	int	4	IN
GetAuthenticationService	P	@AuthenticationID	int	4	IN
GetAuthenticationServiceByPackageID	P	@PackageID	int	4	IN
GetAuthenticationServiceByType	P	@AuthenticationType	nvarchar	100	IN
GetBanner	P	@BannerId	int	4	IN
GetBanner	P	@VendorId	int	4	IN
GetBanner	P	@PortalID	int	4	IN
GetBannerGroups	P	@PortalID	int	4	IN
GetBanners	P	@VendorId	int	4	IN
GetContentItem	P	@ContentItemId	int	4	IN
GetContentItemsByTerm	P	@Term	nvarchar	250	IN
GetDefaultLanguageByModule	P	@ModuleList	varchar	1000	IN
GetDesktopModule	P	@DesktopModuleId	int	4	IN
GetDesktopModuleByFriendlyName	P	@FriendlyName	nvarchar	128	IN
GetDesktopModuleByModuleName	P	@ModuleName	nvarchar	128	IN
GetDesktopModuleByPackageID	P	@PackageID	int	4	IN
GetDesktopModulePermission	P	@DesktopModulePermissionID	int	4	IN
GetDesktopModulePermissionsByPortalDesktopModuleID	P	@PortalDesktopModuleID	int	4	IN
GetDesktopModulesByPortal	P	@PortalId	int	4	IN
GetEventLog	P	@PortalID	int	4	IN
GetEventLog	P	@LogTypeKey	nvarchar	35	IN
GetEventLog	P	@PageSize	int	4	IN
GetEventLog	P	@PageIndex	int	4	IN
GetEventLogByLogGUID	P	@LogGUID	varchar	36	IN
GetEventLogConfig	P	@ID	int	4	IN
GetEventLogPendingNotif	P	@LogConfigID	int	4	IN
GetEventMessages	P	@EventName	nvarchar	100	IN
GetEventMessagesBySubscriber	P	@EventName	nvarchar	100	IN
GetEventMessagesBySubscriber	P	@Subscriber	nvarchar	100	IN
GetFile	P	@FileName	nvarchar	100	IN
GetFile	P	@PortalID	int	4	IN
GetFile	P	@FolderID	int	4	IN
GetFileById	P	@FileId	int	4	IN
GetFileById	P	@PortalID	int	4	IN
GetFileByUniqueID	P	@UniqueID	uniqueidentifier	16	IN
GetFileContent	P	@FileId	int	4	IN
GetFileContent	P	@PortalID	int	4	IN
GetFiles	P	@PortalID	int	4	IN
GetFiles	P	@FolderID	int	4	IN
GetFolderByFolderID	P	@PortalID	int	4	IN
GetFolderByFolderID	P	@FolderID	int	4	IN
GetFolderByFolderPath	P	@PortalID	int	4	IN
GetFolderByFolderPath	P	@FolderPath	nvarchar	300	IN
GetFolderByUniqueID	P	@UniqueID	uniqueidentifier	16	IN
GetFolderPermission	P	@FolderPermissionID	int	4	IN
GetFolderPermissionsByFolderPath	P	@PortalID	int	4	IN
GetFolderPermissionsByFolderPath	P	@FolderPath	varchar	300	IN
GetFolderPermissionsByFolderPath	P	@PermissionID	int	4	IN
GetFolderPermissionsByPortal	P	@PortalId	int	4	IN
GetFolders	P	@PortalID	int	4	IN
GetFolders	P	@FolderID	int	4	IN
GetFolders	P	@FolderPath	nvarchar	300	IN
GetHostSetting	P	@SettingName	nvarchar	50	IN
GetHtmlText	P	@ModuleID	int	4	IN
GetHtmlText	P	@ItemID	int	4	IN
GetHtmlTextLog	P	@ItemID	int	4	IN
GetHtmlTextUser	P	@UserID	int	4	IN
GetLanguagePackByPackage	P	@PackageID	int	4	IN
GetLanguagesByPortal	P	@PortalId	int	4	IN
GetList	P	@ListName	nvarchar	50	IN
GetList	P	@ParentKey	nvarchar	150	IN
GetList	P	@PortalID	int	4	IN
GetListEntries	P	@ListName	nvarchar	50	IN
GetListEntries	P	@ParentKey	nvarchar	150	IN
GetListEntries	P	@PortalID	int	4	IN
GetListEntry	P	@ListName	nvarchar	50	IN
GetListEntry	P	@Value	nvarchar	200	IN
GetListEntry	P	@EntryID	int	4	IN
GetLists	P	@PortalID	int	4	IN
GetMetaData	P	@ContentItemId	int	4	IN
GetModule	P	@ModuleId	int	4	IN
GetModule	P	@TabId	int	4	IN
GetModuleByDefinition	P	@PortalId	int	4	IN
GetModuleByDefinition	P	@FriendlyName	nvarchar	128	IN
GetModuleByUniqueID	P	@UniqueID	uniqueidentifier	16	IN
GetModuleControl	P	@ModuleControlId	int	4	IN
GetModuleControlByKeyAndSrc	P	@ModuleDefId	int	4	IN
GetModuleControlByKeyAndSrc	P	@ControlKey	nvarchar	50	IN
GetModuleControlByKeyAndSrc	P	@ControlSrc	nvarchar	256	IN
GetModuleControlsByKey	P	@ControlKey	nvarchar	50	IN
GetModuleControlsByKey	P	@ModuleDefId	int	4	IN
GetModuleDefinition	P	@ModuleDefId	int	4	IN
GetModuleDefinitionByName	P	@DesktopModuleId	int	4	IN
GetModuleDefinitionByName	P	@FriendlyName	nvarchar	128	IN
GetModulePackagesInUse	P	@PortalID	int	4	IN
GetModulePackagesInUse	P	@ForHost	bit	0	IN
GetModulePermission	P	@ModulePermissionID	int	4	IN
GetModulePermissionsByModuleID	P	@ModuleID	int	4	IN
GetModulePermissionsByModuleID	P	@PermissionID	int	4	IN
GetModulePermissionsByPortal	P	@PortalID	int	4	IN
GetModulePermissionsByTabID	P	@TabID	int	4	IN
GetModules	P	@PortalID	int	4	IN
GetModuleSetting	P	@ModuleId	int	4	IN
GetModuleSetting	P	@SettingName	nvarchar	50	IN
GetModuleSettings	P	@ModuleId	int	4	IN
GetOnlineUser	P	@UserID	int	4	IN
GetOnlineUsers	P	@PortalID	int	4	IN
GetPackage	P	@PackageID	int	4	IN
GetPackageByName	P	@PortalID	int	4	IN
GetPackageByName	P	@Name	nvarchar	128	IN
GetPackages	P	@PortalID	int	4	IN
GetPackagesByType	P	@PortalID	int	4	IN
GetPackagesByType	P	@PackageType	nvarchar	50	IN
GetPackageType	P	@PackageType	nvarchar	50	IN
GetPermission	P	@PermissionID	int	4	IN
GetPermissionByCodeAndKey	P	@PermissionCode	varchar	50	IN
GetPermissionByCodeAndKey	P	@PermissionKey	varchar	50	IN
GetPermissionsByModuleDefID	P	@ModuleDefID	int	4	IN
GetPermissionsByModuleID	P	@ModuleID	int	4	IN
GetPortal	P	@PortalId	int	4	IN
GetPortal	P	@CultureCode	nvarchar	50	IN
GetPortalAlias	P	@HTTPAlias	nvarchar	200	IN
GetPortalAlias	P	@PortalID	int	4	IN
GetPortalAliasByPortalAliasID	P	@PortalAliasID	int	4	IN
GetPortalAliasByPortalID	P	@PortalID	int	4	IN
GetPortalByAlias	P	@HTTPAlias	nvarchar	200	IN
GetPortalByPortalAliasID	P	@PortalAliasId	int	4	IN
GetPortalByTab	P	@TabId	int	4	IN
GetPortalByTab	P	@HTTPAlias	nvarchar	200	IN
GetPortalDefaultLanguage	P	@PortalId	int	4	IN
GetPortalDesktopModules	P	@PortalId	int	4	IN
GetPortalDesktopModules	P	@DesktopModuleId	int	4	IN
GetPortalRoles	P	@PortalId	int	4	IN
GetPortalsByName	P	@NameToMatch	nvarchar	256	IN
GetPortalsByName	P	@PageIndex	int	4	IN
GetPortalsByName	P	@PageSize	int	4	IN
GetPortalSetting	P	@PortalID	int	4	IN
GetPortalSetting	P	@SettingName	nvarchar	50	IN
GetPortalSetting	P	@CultureCode	nvarchar	50	IN
GetPortalSettings	P	@PortalID	int	4	IN
GetPortalSettings	P	@CultureCode	nvarchar	50	IN
GetPortalSpaceUsed	P	@PortalID	int	4	IN
GetProfile	P	@UserID	int	4	IN
GetProfile	P	@PortalID	int	4	IN
GetPropertyDefinition	P	@PropertyDefinitionID	int	4	IN
GetPropertyDefinitionByName	P	@PortalID	int	4	IN
GetPropertyDefinitionByName	P	@Name	nvarchar	50	IN
GetPropertyDefinitionsByCategory	P	@PortalID	int	4	IN
GetPropertyDefinitionsByCategory	P	@Category	nvarchar	50	IN
GetPropertyDefinitionsByPortal	P	@PortalID	int	4	IN
GetRole	P	@RoleId	int	4	IN
GetRole	P	@PortalID	int	4	IN
GetRoleByName	P	@PortalID	int	4	IN
GetRoleByName	P	@RoleName	nvarchar	50	IN
GetRoleGroup	P	@PortalID	int	4	IN
GetRoleGroup	P	@RoleGroupId	int	4	IN
GetRoleGroupByName	P	@PortalID	int	4	IN
GetRoleGroupByName	P	@RoleGroupName	nvarchar	50	IN
GetRoleGroups	P	@PortalID	int	4	IN
GetRolesByGroup	P	@RoleGroupId	int	4	IN
GetRolesByGroup	P	@PortalId	int	4	IN
GetRolesByUser	P	@UserID	int	4	IN
GetRolesByUser	P	@PortalID	int	4	IN
GetSchedule	P	@Server	varchar	150	IN
GetScheduleByEvent	P	@EventName	varchar	50	IN
GetScheduleByEvent	P	@Server	varchar	150	IN
GetScheduleByScheduleID	P	@ScheduleID	int	4	IN
GetScheduleByTypeFullName	P	@TypeFullName	varchar	200	IN
GetScheduleByTypeFullName	P	@Server	varchar	150	IN
GetScheduleHistory	P	@ScheduleID	int	4	IN
GetScheduleItemSettings	P	@ScheduleID	int	4	IN
GetScheduleNextTask	P	@Server	varchar	150	IN
GetSearchCommonWordByID	P	@CommonWordID	int	4	IN
GetSearchCommonWordsByLocale	P	@Locale	nvarchar	10	IN
GetSearchItem	P	@ModuleId	int	4	IN
GetSearchItem	P	@SearchKey	varchar	100	IN
GetSearchItems	P	@PortalID	int	4	IN
GetSearchItems	P	@TabId	int	4	IN
GetSearchItems	P	@ModuleId	int	4	IN
GetSearchItemWord	P	@SearchItemWordID	int	4	IN
GetSearchItemWordBySearchItem	P	@SearchItemID	int	4	IN
GetSearchItemWordBySearchWord	P	@SearchWordsID	int	4	IN
GetSearchItemWordPosition	P	@SearchItemWordPositionID	int	4	IN
GetSearchItemWordPositionBySearchItemWord	P	@SearchItemWordID	int	4	IN
GetSearchModules	P	@PortalID	int	4	IN
GetSearchResultModules	P	@PortalID	int	4	IN
GetSearchResults	P	@PortalID	int	4	IN
GetSearchResults	P	@TabId	int	4	IN
GetSearchResults	P	@ModuleId	int	4	IN
GetSearchResultsByWord	P	@PortalID	int	4	IN
GetSearchResultsByWord	P	@Word	nvarchar	100	IN
GetSearchSettings	P	@ModuleID	int	4	IN
GetSearchWordByID	P	@SearchWordsID	int	4	IN
GetServices	P	@PortalId	int	4	IN
GetServices	P	@UserId	int	4	IN
GetSiteLog1	P	@PortalID	int	4	IN
GetSiteLog1	P	@PortalAlias	nvarchar	50	IN
GetSiteLog1	P	@StartDate	datetime	8	IN
GetSiteLog1	P	@EndDate	datetime	8	IN
GetSiteLog12	P	@PortalID	int	4	IN
GetSiteLog12	P	@PortalAlias	nvarchar	50	IN
GetSiteLog12	P	@StartDate	datetime	8	IN
GetSiteLog12	P	@EndDate	datetime	8	IN
GetSiteLog2	P	@PortalID	int	4	IN
GetSiteLog2	P	@PortalAlias	nvarchar	50	IN
GetSiteLog2	P	@StartDate	datetime	8	IN
GetSiteLog2	P	@EndDate	datetime	8	IN
GetSiteLog3	P	@PortalID	int	4	IN
GetSiteLog3	P	@PortalAlias	nvarchar	50	IN
GetSiteLog3	P	@StartDate	datetime	8	IN
GetSiteLog3	P	@EndDate	datetime	8	IN
GetSiteLog4	P	@PortalID	int	4	IN
GetSiteLog4	P	@PortalAlias	nvarchar	50	IN
GetSiteLog4	P	@StartDate	datetime	8	IN
GetSiteLog4	P	@EndDate	datetime	8	IN
GetSiteLog5	P	@PortalID	int	4	IN
GetSiteLog5	P	@PortalAlias	nvarchar	50	IN
GetSiteLog5	P	@StartDate	datetime	8	IN
GetSiteLog5	P	@EndDate	datetime	8	IN
GetSiteLog6	P	@PortalID	int	4	IN
GetSiteLog6	P	@PortalAlias	nvarchar	50	IN
GetSiteLog6	P	@StartDate	datetime	8	IN
GetSiteLog6	P	@EndDate	datetime	8	IN
GetSiteLog7	P	@PortalID	int	4	IN
GetSiteLog7	P	@PortalAlias	nvarchar	50	IN
GetSiteLog7	P	@StartDate	datetime	8	IN
GetSiteLog7	P	@EndDate	datetime	8	IN
GetSiteLog8	P	@PortalID	int	4	IN
GetSiteLog8	P	@PortalAlias	nvarchar	50	IN
GetSiteLog8	P	@StartDate	datetime	8	IN
GetSiteLog8	P	@EndDate	datetime	8	IN
GetSiteLog9	P	@PortalID	int	4	IN
GetSiteLog9	P	@PortalAlias	nvarchar	50	IN
GetSiteLog9	P	@StartDate	datetime	8	IN
GetSiteLog9	P	@EndDate	datetime	8	IN
GetSkinControl	P	@SkinControlID	int	4	IN
GetSkinControlByKey	P	@ControlKey	nvarchar	50	IN
GetSkinControlByPackageID	P	@PackageID	int	4	IN
GetSkinPackage	P	@PortalID	int	4	IN
GetSkinPackage	P	@SkinName	nvarchar	50	IN
GetSkinPackage	P	@SkinType	nvarchar	50	IN
GetSkinPackageByPackageID	P	@PackageID	int	4	IN
GetSystemMessage	P	@PortalID	int	4	IN
GetSystemMessage	P	@MessageName	nvarchar	50	IN
GetTab	P	@TabId	int	4	IN
GetTabByName	P	@TabName	nvarchar	50	IN
GetTabByName	P	@PortalID	int	4	IN
GetTabByUniqueID	P	@UniqueID	uniqueidentifier	16	IN
GetTabCount	P	@PortalId	int	4	IN
GetTabModule	P	@TabModuleID	int	4	IN
GetTabModuleOrder	P	@TabId	int	4	IN
GetTabModuleOrder	P	@PaneName	nvarchar	50	IN
GetTabModules	P	@TabId	int	4	IN
GetTabModuleSetting	P	@TabModuleId	int	4	IN
GetTabModuleSetting	P	@SettingName	nvarchar	50	IN
GetTabModuleSettings	P	@TabModuleId	int	4	IN
GetTabPanes	P	@TabId	int	4	IN
GetTabPaths	P	@PortalID	int	4	IN
GetTabPaths	P	@CultureCode	nvarchar	10	IN
GetTabPermission	P	@TabPermissionID	int	4	IN
GetTabPermissionsByPortal	P	@PortalID	int	4	IN
GetTabPermissionsByTabID	P	@TabID	int	4	IN
GetTabPermissionsByTabID	P	@PermissionID	int	4	IN
GetTabs	P	@PortalID	int	4	IN
GetTabsByModuleID	P	@ModuleID	int	4	IN
GetTabsByPackageID	P	@PortalID	int	4	IN
GetTabsByPackageID	P	@PackageID	int	4	IN
GetTabsByPackageID	P	@ForHost	bit	0	IN
GetTabsByParentId	P	@ParentId	int	4	IN
GetTabSetting	P	@TabID	int	4	IN
GetTabSetting	P	@SettingName	nvarchar	50	IN
GetTabSettings	P	@TabID	int	4	IN
GetTerm	P	@TermId	int	4	IN
GetTermsByContent	P	@ContentItemID	int	4	IN
GetTermsByVocabulary	P	@VocabularyID	int	4	IN
GetTopHtmlText	P	@ModuleID	int	4	IN
GetTopHtmlText	P	@IsPublished	bit	0	IN
GetUnAuthorizedUsers	P	@PortalID	int	4	IN
GetUrl	P	@PortalID	int	4	IN
GetUrl	P	@Url	nvarchar	255	IN
GetUrlLog	P	@URLTrackingID	int	4	IN
GetUrlLog	P	@StartDate	datetime	8	IN
GetUrlLog	P	@EndDate	datetime	8	IN
GetUrls	P	@PortalID	int	4	IN
GetUrlTracking	P	@PortalID	int	4	IN
GetUrlTracking	P	@Url	nvarchar	255	IN
GetUrlTracking	P	@ModuleId	int	4	IN
GetUser	P	@PortalID	int	4	IN
GetUser	P	@UserID	int	4	IN
GetUserByAuthToken	P	@PortalId	int	4	IN
GetUserByAuthToken	P	@UserToken	nvarchar	1000	IN
GetUserByAuthToken	P	@AuthType	nvarchar	100	IN
GetUserByUsername	P	@PortalID	int	4	IN
GetUserByUsername	P	@Username	nvarchar	100	IN
GetUserCountByPortal	P	@PortalId	int	4	IN
GetUserProfile	P	@UserID	int	4	IN
GetUserRole	P	@PortalID	int	4	IN
GetUserRole	P	@UserID	int	4	IN
GetUserRole	P	@RoleId	int	4	IN
GetUserRoles	P	@PortalId	int	4	IN
GetUserRoles	P	@UserId	int	4	IN
GetUserRolesByUsername	P	@PortalID	int	4	IN
GetUserRolesByUsername	P	@Username	nvarchar	100	IN
GetUserRolesByUsername	P	@Rolename	nvarchar	50	IN
GetUsers	P	@PortalID	int	4	IN
GetUsersByEmail	P	@PortalID	int	4	IN
GetUsersByEmail	P	@EmailToMatch	nvarchar	256	IN
GetUsersByEmail	P	@PageIndex	int	4	IN
GetUsersByEmail	P	@PageSize	int	4	IN
GetUsersByProfileProperty	P	@PortalID	int	4	IN
GetUsersByProfileProperty	P	@PropertyName	nvarchar	256	IN
GetUsersByProfileProperty	P	@PropertyValue	nvarchar	256	IN
GetUsersByProfileProperty	P	@PageIndex	int	4	IN
GetUsersByProfileProperty	P	@PageSize	int	4	IN
GetUsersByRolename	P	@PortalID	int	4	IN
GetUsersByRolename	P	@Rolename	nvarchar	50	IN
GetUsersByUserName	P	@PortalID	int	4	IN
GetUsersByUserName	P	@UserNameToMatch	nvarchar	256	IN
GetUsersByUserName	P	@PageIndex	int	4	IN
GetUsersByUserName	P	@PageSize	int	4	IN
GetVendor	P	@VendorId	int	4	IN
GetVendor	P	@PortalID	int	4	IN
GetVendorClassifications	P	@VendorId	int	4	IN
GetVendors	P	@PortalID	int	4	IN
GetVendors	P	@UnAuthorized	bit	0	IN
GetVendors	P	@PageSize	int	4	IN
GetVendors	P	@PageIndex	int	4	IN
GetVendorsByEmail	P	@Filter	nvarchar	50	IN
GetVendorsByEmail	P	@PortalID	int	4	IN
GetVendorsByEmail	P	@PageSize	int	4	IN
GetVendorsByEmail	P	@PageIndex	int	4	IN
GetVendorsByName	P	@Filter	nvarchar	50	IN
GetVendorsByName	P	@PortalID	int	4	IN
GetVendorsByName	P	@PageSize	int	4	IN
GetVendorsByName	P	@PageIndex	int	4	IN
GetWorkflows	P	@PortalID	int	4	IN
GetWorkflowStates	P	@WorkflowID	int	4	IN
InsertPortalLocalization	P	@PortalID	int	4	IN
InsertPortalLocalization	P	@CultureCode	nvarchar	10	IN
InsertPortalLocalization	P	@PortalName	nvarchar	128	IN
InsertPortalLocalization	P	@LogoFile	nvarchar	50	IN
InsertPortalLocalization	P	@FooterText	nvarchar	100	IN
InsertPortalLocalization	P	@Description	nvarchar	500	IN
InsertPortalLocalization	P	@KeyWords	nvarchar	500	IN
InsertPortalLocalization	P	@BackgroundFile	nvarchar	50	IN
InsertPortalLocalization	P	@HomeTabId	int	4	IN
InsertPortalLocalization	P	@LoginTabId	int	4	IN
InsertPortalLocalization	P	@UserTabId	int	4	IN
InsertPortalLocalization	P	@AdminTabid	int	4	IN
InsertPortalLocalization	P	@SplashTabId	int	4	IN
InsertPortalLocalization	P	@CreatedByUserID	int	4	IN
IsUserInRole	P	@UserID	int	4	IN
IsUserInRole	P	@RoleId	int	4	IN
IsUserInRole	P	@PortalID	int	4	IN
Messaging_GetInbox	P	@PortalID	int	4	IN
Messaging_GetInbox	P	@UserID	int	4	IN
Messaging_GetInbox	P	@PageNumber	int	4	IN
Messaging_GetInbox	P	@PageSize	int	4	IN
Messaging_GetInboxCount	P	@PortalID	int	4	IN
Messaging_GetInboxCount	P	@UserID	int	4	IN
Messaging_GetMessage	P	@MessageID	bigint	8	IN
Messaging_GetNewMessageCount	P	@PortalID	int	4	IN
Messaging_GetNewMessageCount	P	@UserID	int	4	IN
Messaging_GetNextMessageForDispatch	P	@SchedulerInstance	uniqueidentifier	16	IN
Messaging_MarkMessageAsDispatched	P	@MessageId	int	4	IN
Messaging_Save_Message	P	@PortalID	int	4	IN
Messaging_Save_Message	P	@FromUserID	int	4	IN
Messaging_Save_Message	P	@ToUserID	int	4	IN
Messaging_Save_Message	P	@ToRoleID	int	4	IN
Messaging_Save_Message	P	@Status	int	4	IN
Messaging_Save_Message	P	@Subject	nvarchar	-1	IN
Messaging_Save_Message	P	@Body	nvarchar	-1	IN
Messaging_Save_Message	P	@Date	datetime	8	IN
Messaging_Save_Message	P	@Conversation	uniqueidentifier	16	IN
Messaging_Save_Message	P	@ReplyTo	bigint	8	IN
Messaging_Save_Message	P	@AllowReply	bit	0	IN
Messaging_Save_Message	P	@SkipPortal	bit	0	IN
Messaging_UpdateMessage	P	@MessageID	bigint	8	IN
Messaging_UpdateMessage	P	@ToUserID	int	4	IN
Messaging_UpdateMessage	P	@ToRoleID	int	4	IN
Messaging_UpdateMessage	P	@Status	int	4	IN
Messaging_UpdateMessage	P	@Subject	nvarchar	-1	IN
Messaging_UpdateMessage	P	@Body	nvarchar	-1	IN
Messaging_UpdateMessage	P	@Date	datetime	8	IN
Messaging_UpdateMessage	P	@ReplyTo	bigint	8	IN
Messaging_UpdateMessage	P	@AllowReply	bit	0	IN
Messaging_UpdateMessage	P	@SkipPortal	bit	0	IN
MoveTabModule	P	@FromTabId	int	4	IN
MoveTabModule	P	@ModuleId	int	4	IN
MoveTabModule	P	@ToTabId	int	4	IN
MoveTabModule	P	@PaneName	nvarchar	50	IN
MoveTabModule	P	@LastModifiedByUserID	int	4	IN
RegisterAssembly	P	@PackageID	int	4	IN
RegisterAssembly	P	@AssemblyName	nvarchar	250	IN
RegisterAssembly	P	@Version	nvarchar	20	IN
RemoveTermsFromContent	P	@ContentItemID	int	4	IN
RestoreTabModule	P	@TabId	int	4	IN
RestoreTabModule	P	@ModuleId	int	4	IN
SaveCoreAuditTypes	P	@LogTypeKey	nvarchar	35	IN
SaveCoreAuditTypes	P	@LogTypeFriendlyName	nvarchar	50	IN
SaveCoreAuditTypes	P	@LogTypeOwner	nvarchar	100	IN
SaveCoreAuditTypes	P	@LogTypeCSSClass	nvarchar	40	IN
SaveCoreAuditTypes	P	@LoggingIsActive	bit	0	IN
SaveCoreAuditTypes	P	@KeepMostRecent	int	4	IN
SaveCoreAuditTypes	P	@EmailNotificationIsActive	bit	0	IN
SetEventMessageComplete	P	@EventMessageID	int	4	IN
UnRegisterAssembly	P	@PackageID	int	4	IN
UnRegisterAssembly	P	@AssemblyName	nvarchar	250	IN
UpdateAffiliate	P	@AffiliateId	int	4	IN
UpdateAffiliate	P	@StartDate	datetime	8	IN
UpdateAffiliate	P	@EndDate	datetime	8	IN
UpdateAffiliate	P	@CPC	float	4	IN
UpdateAffiliate	P	@CPA	float	4	IN
UpdateAffiliateStats	P	@AffiliateId	int	4	IN
UpdateAffiliateStats	P	@Clicks	int	4	IN
UpdateAffiliateStats	P	@Acquisitions	int	4	IN
UpdateAnonymousUser	P	@UserID	char	36	IN
UpdateAnonymousUser	P	@PortalID	int	4	IN
UpdateAnonymousUser	P	@TabID	int	4	IN
UpdateAnonymousUser	P	@LastActiveDate	datetime	8	IN
UpdateAuthentication	P	@AuthenticationID	int	4	IN
UpdateAuthentication	P	@PackageID	int	4	IN
UpdateAuthentication	P	@AuthenticationType	nvarchar	100	IN
UpdateAuthentication	P	@IsEnabled	bit	0	IN
UpdateAuthentication	P	@SettingsControlSrc	nvarchar	250	IN
UpdateAuthentication	P	@LoginControlSrc	nvarchar	250	IN
UpdateAuthentication	P	@LogoffControlSrc	nvarchar	250	IN
UpdateAuthentication	P	@LastModifiedByUserID	int	4	IN
UpdateBanner	P	@BannerId	int	4	IN
UpdateBanner	P	@BannerName	nvarchar	100	IN
UpdateBanner	P	@ImageFile	nvarchar	100	IN
UpdateBanner	P	@URL	nvarchar	255	IN
UpdateBanner	P	@Impressions	int	4	IN
UpdateBanner	P	@CPM	float	4	IN
UpdateBanner	P	@StartDate	datetime	8	IN
UpdateBanner	P	@EndDate	datetime	8	IN
UpdateBanner	P	@UserName	nvarchar	100	IN
UpdateBanner	P	@BannerTypeId	int	4	IN
UpdateBanner	P	@Description	nvarchar	2000	IN
UpdateBanner	P	@GroupName	nvarchar	100	IN
UpdateBanner	P	@Criteria	bit	0	IN
UpdateBanner	P	@Width	int	4	IN
UpdateBanner	P	@Height	int	4	IN
UpdateBannerClickThrough	P	@BannerId	int	4	IN
UpdateBannerClickThrough	P	@VendorId	int	4	IN
UpdateBannerViews	P	@BannerId	int	4	IN
UpdateBannerViews	P	@StartDate	datetime	8	IN
UpdateBannerViews	P	@EndDate	datetime	8	IN
UpdateContentItem	P	@ContentItemID	int	4	IN
UpdateContentItem	P	@Content	nvarchar	-1	IN
UpdateContentItem	P	@ContentTypeID	int	4	IN
UpdateContentItem	P	@TabID	int	4	IN
UpdateContentItem	P	@ModuleID	int	4	IN
UpdateContentItem	P	@ContentKey	nvarchar	250	IN
UpdateContentItem	P	@Indexed	bit	0	IN
UpdateContentItem	P	@LastModifiedByUserID	int	4	IN
UpdateContentType	P	@ContentTypeId	int	4	IN
UpdateContentType	P	@ContentType	nvarchar	250	IN
UpdateDatabaseVersion	P	@Major	int	4	IN
UpdateDatabaseVersion	P	@Minor	int	4	IN
UpdateDatabaseVersion	P	@Build	int	4	IN
UpdateDatabaseVersionAndName	P	@Major	int	4	IN
UpdateDatabaseVersionAndName	P	@Minor	int	4	IN
UpdateDatabaseVersionAndName	P	@Build	int	4	IN
UpdateDatabaseVersionAndName	P	@Name	nvarchar	50	IN
UpdateDesktopModule	P	@DesktopModuleId	int	4	IN
UpdateDesktopModule	P	@PackageID	int	4	IN
UpdateDesktopModule	P	@ModuleName	nvarchar	128	IN
UpdateDesktopModule	P	@FolderName	nvarchar	128	IN
UpdateDesktopModule	P	@FriendlyName	nvarchar	128	IN
UpdateDesktopModule	P	@Description	nvarchar	2000	IN
UpdateDesktopModule	P	@Version	nvarchar	8	IN
UpdateDesktopModule	P	@IsPremium	bit	0	IN
UpdateDesktopModule	P	@IsAdmin	bit	0	IN
UpdateDesktopModule	P	@BusinessController	nvarchar	200	IN
UpdateDesktopModule	P	@SupportedFeatures	int	4	IN
UpdateDesktopModule	P	@CompatibleVersions	nvarchar	500	IN
UpdateDesktopModule	P	@Dependencies	nvarchar	400	IN
UpdateDesktopModule	P	@Permissions	nvarchar	400	IN
UpdateDesktopModule	P	@LastModifiedByUserID	int	4	IN
UpdateDesktopModulePermission	P	@DesktopModulePermissionID	int	4	IN
UpdateDesktopModulePermission	P	@PortalDesktopModuleID	int	4	IN
UpdateDesktopModulePermission	P	@PermissionID	int	4	IN
UpdateDesktopModulePermission	P	@RoleID	int	4	IN
UpdateDesktopModulePermission	P	@AllowAccess	bit	0	IN
UpdateDesktopModulePermission	P	@UserID	int	4	IN
UpdateDesktopModulePermission	P	@LastModifiedByUserID	int	4	IN
UpdateEventLogConfig	P	@ID	int	4	IN
UpdateEventLogConfig	P	@LogTypeKey	nvarchar	35	IN
UpdateEventLogConfig	P	@LogTypePortalID	int	4	IN
UpdateEventLogConfig	P	@LoggingIsActive	bit	0	IN
UpdateEventLogConfig	P	@KeepMostRecent	int	4	IN
UpdateEventLogConfig	P	@EmailNotificationIsActive	bit	0	IN
UpdateEventLogConfig	P	@NotificationThreshold	int	4	IN
UpdateEventLogConfig	P	@NotificationThresholdTime	int	4	IN
UpdateEventLogConfig	P	@NotificationThresholdTimeType	int	4	IN
UpdateEventLogConfig	P	@MailFromAddress	nvarchar	50	IN
UpdateEventLogConfig	P	@MailToAddress	nvarchar	50	IN
UpdateEventLogPendingNotif	P	@LogConfigID	int	4	IN
UpdateEventLogType	P	@LogTypeKey	nvarchar	35	IN
UpdateEventLogType	P	@LogTypeFriendlyName	nvarchar	50	IN
UpdateEventLogType	P	@LogTypeDescription	nvarchar	128	IN
UpdateEventLogType	P	@LogTypeOwner	nvarchar	100	IN
UpdateEventLogType	P	@LogTypeCSSClass	nvarchar	40	IN
UpdateFile	P	@FileId	int	4	IN
UpdateFile	P	@VersionGuid	uniqueidentifier	16	IN
UpdateFile	P	@FileName	nvarchar	100	IN
UpdateFile	P	@Extension	nvarchar	100	IN
UpdateFile	P	@Size	int	4	IN
UpdateFile	P	@Width	int	4	IN
UpdateFile	P	@Height	int	4	IN
UpdateFile	P	@ContentType	nvarchar	200	IN
UpdateFile	P	@Folder	nvarchar	200	IN
UpdateFile	P	@FolderID	int	4	IN
UpdateFile	P	@LastModifiedByUserID	int	4	IN
UpdateFile	P	@Hash	varchar	40	IN
UpdateFileContent	P	@FileId	int	4	IN
UpdateFileContent	P	@Content	image		IN
UpdateFileVersion	P	@FileID	int	4	IN
UpdateFileVersion	P	@VersionGuid	uniqueidentifier	16	IN
UpdateFolder	P	@PortalID	int	4	IN
UpdateFolder	P	@VersionGuid	uniqueidentifier	16	IN
UpdateFolder	P	@FolderID	int	4	IN
UpdateFolder	P	@FolderPath	varchar	300	IN
UpdateFolder	P	@StorageLocation	int	4	IN
UpdateFolder	P	@IsProtected	bit	0	IN
UpdateFolder	P	@IsCached	bit	0	IN
UpdateFolder	P	@LastUpdated	datetime	8	IN
UpdateFolder	P	@LastModifiedByUserID	int	4	IN
UpdateFolderPermission	P	@FolderPermissionID	int	4	IN
UpdateFolderPermission	P	@FolderID	int	4	IN
UpdateFolderPermission	P	@PermissionID	int	4	IN
UpdateFolderPermission	P	@RoleID	int	4	IN
UpdateFolderPermission	P	@AllowAccess	bit	0	IN
UpdateFolderPermission	P	@UserID	int	4	IN
UpdateFolderPermission	P	@LastModifiedByUserID	int	4	IN
UpdateFolderVersion	P	@FolderID	int	4	IN
UpdateFolderVersion	P	@VersionGuid	uniqueidentifier	16	IN
UpdateHeirarchicalTerm	P	@TermID	int	4	IN
UpdateHeirarchicalTerm	P	@VocabularyID	int	4	IN
UpdateHeirarchicalTerm	P	@ParentTermID	int	4	IN
UpdateHeirarchicalTerm	P	@Name	nvarchar	250	IN
UpdateHeirarchicalTerm	P	@Description	nvarchar	2500	IN
UpdateHeirarchicalTerm	P	@Weight	int	4	IN
UpdateHeirarchicalTerm	P	@LastModifiedByUserID	int	4	IN
UpdateHostSetting	P	@SettingName	nvarchar	50	IN
UpdateHostSetting	P	@SettingValue	nvarchar	256	IN
UpdateHostSetting	P	@SettingIsSecure	bit	0	IN
UpdateHostSetting	P	@LastModifiedByUserID	int	4	IN
UpdateHtmlText	P	@ItemID	int	4	IN
UpdateHtmlText	P	@Content	ntext	1073741823	IN
UpdateHtmlText	P	@StateID	int	4	IN
UpdateHtmlText	P	@IsPublished	bit	0	IN
UpdateHtmlText	P	@UserID	int	4	IN
UpdateLanguage	P	@LanguageID	int	4	IN
UpdateLanguage	P	@CultureCode	nvarchar	50	IN
UpdateLanguage	P	@CultureName	nvarchar	200	IN
UpdateLanguage	P	@FallbackCulture	nvarchar	50	IN
UpdateLanguage	P	@LastModifiedByUserID	int	4	IN
UpdateLanguagePack	P	@LanguagePackID	int	4	IN
UpdateLanguagePack	P	@PackageID	int	4	IN
UpdateLanguagePack	P	@LanguageID	int	4	IN
UpdateLanguagePack	P	@DependentPackageID	int	4	IN
UpdateLanguagePack	P	@LastModifiedByUserID	int	4	IN
UpdateListEntry	P	@EntryID	int	4	IN
UpdateListEntry	P	@Value	nvarchar	100	IN
UpdateListEntry	P	@Text	nvarchar	150	IN
UpdateListEntry	P	@Description	nvarchar	500	IN
UpdateListEntry	P	@LastModifiedByUserID	int	4	IN
UpdateListSortOrder	P	@EntryID	int	4	IN
UpdateListSortOrder	P	@MoveUp	bit	0	IN
UpdateModule	P	@ModuleId	int	4	IN
UpdateModule	P	@ContentItemID	int	4	IN
UpdateModule	P	@AllTabs	bit	0	IN
UpdateModule	P	@StartDate	datetime	8	IN
UpdateModule	P	@EndDate	datetime	8	IN
UpdateModule	P	@InheritViewPermissions	bit	0	IN
UpdateModule	P	@IsDeleted	bit	0	IN
UpdateModule	P	@LastModifiedByUserID	int	4	IN
UpdateModuleControl	P	@ModuleControlId	int	4	IN
UpdateModuleControl	P	@ModuleDefID	int	4	IN
UpdateModuleControl	P	@ControlKey	nvarchar	50	IN
UpdateModuleControl	P	@ControlTitle	nvarchar	50	IN
UpdateModuleControl	P	@ControlSrc	nvarchar	256	IN
UpdateModuleControl	P	@IconFile	nvarchar	100	IN
UpdateModuleControl	P	@ControlType	int	4	IN
UpdateModuleControl	P	@ViewOrder	int	4	IN
UpdateModuleControl	P	@HelpUrl	nvarchar	200	IN
UpdateModuleControl	P	@SupportsPartialRendering	bit	0	IN
UpdateModuleControl	P	@LastModifiedByUserID	int	4	IN
UpdateModuleDefinition	P	@ModuleDefId	int	4	IN
UpdateModuleDefinition	P	@FriendlyName	nvarchar	128	IN
UpdateModuleDefinition	P	@DefaultCacheTime	int	4	IN
UpdateModuleDefinition	P	@LastModifiedByUserID	int	4	IN
UpdateModuleOrder	P	@TabId	int	4	IN
UpdateModuleOrder	P	@ModuleId	int	4	IN
UpdateModuleOrder	P	@ModuleOrder	int	4	IN
UpdateModuleOrder	P	@PaneName	nvarchar	50	IN
UpdateModulePermission	P	@ModulePermissionID	int	4	IN
UpdateModulePermission	P	@ModuleID	int	4	IN
UpdateModulePermission	P	@PermissionID	int	4	IN
UpdateModulePermission	P	@RoleID	int	4	IN
UpdateModulePermission	P	@AllowAccess	bit	0	IN
UpdateModulePermission	P	@LastModifiedByUserID	int	4	IN
UpdateModuleSetting	P	@ModuleId	int	4	IN
UpdateModuleSetting	P	@SettingName	nvarchar	50	IN
UpdateModuleSetting	P	@SettingValue	nvarchar	2000	IN
UpdateModuleSetting	P	@LastModifiedByUserID	int	4	IN
UpdateOnlineUser	P	@UserID	int	4	IN
UpdateOnlineUser	P	@PortalID	int	4	IN
UpdateOnlineUser	P	@TabID	int	4	IN
UpdateOnlineUser	P	@LastActiveDate	datetime	8	IN
UpdatePackage	P	@PortalID	int	4	IN
UpdatePackage	P	@Name	nvarchar	128	IN
UpdatePackage	P	@FriendlyName	nvarchar	250	IN
UpdatePackage	P	@Description	nvarchar	2000	IN
UpdatePackage	P	@PackageType	nvarchar	50	IN
UpdatePackage	P	@Version	nvarchar	50	IN
UpdatePackage	P	@License	ntext	1073741823	IN
UpdatePackage	P	@Manifest	ntext	1073741823	IN
UpdatePackage	P	@Owner	nvarchar	100	IN
UpdatePackage	P	@Organization	nvarchar	100	IN
UpdatePackage	P	@Url	nvarchar	250	IN
UpdatePackage	P	@Email	nvarchar	100	IN
UpdatePackage	P	@ReleaseNotes	ntext	1073741823	IN
UpdatePackage	P	@IsSystemPackage	bit	0	IN
UpdatePackage	P	@LastModifiedByUserID	int	4	IN
UpdatePermission	P	@PermissionID	int	4	IN
UpdatePermission	P	@PermissionCode	varchar	50	IN
UpdatePermission	P	@ModuleDefID	int	4	IN
UpdatePermission	P	@PermissionKey	varchar	50	IN
UpdatePermission	P	@PermissionName	varchar	50	IN
UpdatePermission	P	@LastModifiedByUserID	int	4	IN
UpdatePortalAlias	P	@PortalAliasID	int	4	IN
UpdatePortalAlias	P	@PortalID	int	4	IN
UpdatePortalAlias	P	@HTTPAlias	nvarchar	200	IN
UpdatePortalAlias	P	@LastModifiedByUserID	int	4	IN
UpdatePortalAliasOnInstall	P	@PortalAlias	nvarchar	200	IN
UpdatePortalAliasOnInstall	P	@LastModifiedByUserID	int	4	IN
UpdatePortalDefaultLanguage	P	@PortalId	int	4	IN
UpdatePortalDefaultLanguage	P	@CultureCode	nvarchar	50	IN
UpdatePortalInfo	P	@PortalID	int	4	IN
UpdatePortalInfo	P	@PortalName	nvarchar	128	IN
UpdatePortalInfo	P	@LogoFile	nvarchar	50	IN
UpdatePortalInfo	P	@FooterText	nvarchar	100	IN
UpdatePortalInfo	P	@ExpiryDate	datetime	8	IN
UpdatePortalInfo	P	@UserRegistration	int	4	IN
UpdatePortalInfo	P	@BannerAdvertising	int	4	IN
UpdatePortalInfo	P	@Currency	char	3	IN
UpdatePortalInfo	P	@AdministratorId	int	4	IN
UpdatePortalInfo	P	@HostFee	money	8	IN
UpdatePortalInfo	P	@HostSpace	int	4	IN
UpdatePortalInfo	P	@PageQuota	int	4	IN
UpdatePortalInfo	P	@UserQuota	int	4	IN
UpdatePortalInfo	P	@PaymentProcessor	nvarchar	50	IN
UpdatePortalInfo	P	@ProcessorUserId	nvarchar	50	IN
UpdatePortalInfo	P	@ProcessorPassword	nvarchar	50	IN
UpdatePortalInfo	P	@Description	nvarchar	500	IN
UpdatePortalInfo	P	@KeyWords	nvarchar	500	IN
UpdatePortalInfo	P	@BackgroundFile	nvarchar	50	IN
UpdatePortalInfo	P	@SiteLogHistory	int	4	IN
UpdatePortalInfo	P	@SplashTabId	int	4	IN
UpdatePortalInfo	P	@HomeTabId	int	4	IN
UpdatePortalInfo	P	@LoginTabId	int	4	IN
UpdatePortalInfo	P	@RegisterTabId	int	4	IN
UpdatePortalInfo	P	@UserTabId	int	4	IN
UpdatePortalInfo	P	@SearchTabId	int	4	IN
UpdatePortalInfo	P	@DefaultLanguage	nvarchar	10	IN
UpdatePortalInfo	P	@TimeZoneOffset	int	4	IN
UpdatePortalInfo	P	@HomeDirectory	varchar	100	IN
UpdatePortalInfo	P	@LastModifiedByUserID	int	4	IN
UpdatePortalInfo	P	@CultureCode	nvarchar	50	IN
UpdatePortalLanguage	P	@PortalId	int	4	IN
UpdatePortalLanguage	P	@LanguageId	int	4	IN
UpdatePortalLanguage	P	@IsPublished	bit	0	IN
UpdatePortalLanguage	P	@LastModifiedByUserID	int	4	IN
UpdatePortalSetting	P	@PortalID	int	4	IN
UpdatePortalSetting	P	@SettingName	nvarchar	50	IN
UpdatePortalSetting	P	@SettingValue	nvarchar	2000	IN
UpdatePortalSetting	P	@UserID	int	4	IN
UpdatePortalSetting	P	@CultureCode	nvarchar	50	IN
UpdatePortalSetup	P	@PortalId	int	4	IN
UpdatePortalSetup	P	@AdministratorId	int	4	IN
UpdatePortalSetup	P	@AdministratorRoleId	int	4	IN
UpdatePortalSetup	P	@RegisteredRoleId	int	4	IN
UpdatePortalSetup	P	@SplashTabId	int	4	IN
UpdatePortalSetup	P	@HomeTabId	int	4	IN
UpdatePortalSetup	P	@LoginTabId	int	4	IN
UpdatePortalSetup	P	@RegisterTabId	int	4	IN
UpdatePortalSetup	P	@UserTabId	int	4	IN
UpdatePortalSetup	P	@SearchTabId	int	4	IN
UpdatePortalSetup	P	@AdminTabId	int	4	IN
UpdatePortalSetup	P	@CultureCode	nvarchar	50	IN
UpdateProfile	P	@UserID	int	4	IN
UpdateProfile	P	@PortalID	int	4	IN
UpdateProfile	P	@ProfileData	ntext	1073741823	IN
UpdatePropertyDefinition	P	@PropertyDefinitionId	int	4	IN
UpdatePropertyDefinition	P	@DataType	int	4	IN
UpdatePropertyDefinition	P	@DefaultValue	nvarchar	50	IN
UpdatePropertyDefinition	P	@PropertyCategory	nvarchar	50	IN
UpdatePropertyDefinition	P	@PropertyName	nvarchar	50	IN
UpdatePropertyDefinition	P	@Required	bit	0	IN
UpdatePropertyDefinition	P	@ValidationExpression	nvarchar	100	IN
UpdatePropertyDefinition	P	@ViewOrder	int	4	IN
UpdatePropertyDefinition	P	@Visible	bit	0	IN
UpdatePropertyDefinition	P	@Length	int	4	IN
UpdatePropertyDefinition	P	@DefaultVisibility	int	4	IN
UpdatePropertyDefinition	P	@LastModifiedByUserID	int	4	IN
UpdateRole	P	@RoleId	int	4	IN
UpdateRole	P	@RoleGroupId	int	4	IN
UpdateRole	P	@Description	nvarchar	1000	IN
UpdateRole	P	@ServiceFee	money	8	IN
UpdateRole	P	@BillingPeriod	int	4	IN
UpdateRole	P	@BillingFrequency	char	1	IN
UpdateRole	P	@TrialFee	money	8	IN
UpdateRole	P	@TrialPeriod	int	4	IN
UpdateRole	P	@TrialFrequency	char	1	IN
UpdateRole	P	@IsPublic	bit	0	IN
UpdateRole	P	@AutoAssignment	bit	0	IN
UpdateRole	P	@RSVPCode	nvarchar	50	IN
UpdateRole	P	@IconFile	nvarchar	100	IN
UpdateRole	P	@LastModifiedByUserID	int	4	IN
UpdateRoleGroup	P	@RoleGroupId	int	4	IN
UpdateRoleGroup	P	@RoleGroupName	nvarchar	50	IN
UpdateRoleGroup	P	@Description	nvarchar	1000	IN
UpdateRoleGroup	P	@LastModifiedUserID	int	4	IN
UpdateSchedule	P	@ScheduleID	int	4	IN
UpdateSchedule	P	@TypeFullName	varchar	200	IN
UpdateSchedule	P	@TimeLapse	int	4	IN
UpdateSchedule	P	@TimeLapseMeasurement	varchar	2	IN
UpdateSchedule	P	@RetryTimeLapse	int	4	IN
UpdateSchedule	P	@RetryTimeLapseMeasurement	varchar	2	IN
UpdateSchedule	P	@RetainHistoryNum	int	4	IN
UpdateSchedule	P	@AttachToEvent	varchar	50	IN
UpdateSchedule	P	@CatchUpEnabled	bit	0	IN
UpdateSchedule	P	@Enabled	bit	0	IN
UpdateSchedule	P	@ObjectDependencies	varchar	300	IN
UpdateSchedule	P	@Servers	varchar	150	IN
UpdateSchedule	P	@LastModifiedByUserID	int	4	IN
UpdateSchedule	P	@FriendlyName	varchar	200	IN
UpdateScheduleHistory	P	@ScheduleHistoryID	int	4	IN
UpdateScheduleHistory	P	@EndDate	datetime	8	IN
UpdateScheduleHistory	P	@Succeeded	bit	0	IN
UpdateScheduleHistory	P	@LogNotes	ntext	1073741823	IN
UpdateScheduleHistory	P	@NextStart	datetime	8	IN
UpdateScopeType	P	@ScopeTypeId	int	4	IN
UpdateScopeType	P	@ScopeType	nvarchar	250	IN
UpdateSearchCommonWord	P	@CommonWordID	int	4	IN
UpdateSearchCommonWord	P	@CommonWord	nvarchar	255	IN
UpdateSearchCommonWord	P	@Locale	nvarchar	10	IN
UpdateSearchItem	P	@SearchItemID	int	4	IN
UpdateSearchItem	P	@Title	nvarchar	200	IN
UpdateSearchItem	P	@Description	nvarchar	2000	IN
UpdateSearchItem	P	@Author	int	4	IN
UpdateSearchItem	P	@PubDate	datetime	8	IN
UpdateSearchItem	P	@ModuleId	int	4	IN
UpdateSearchItem	P	@SearchKey	nvarchar	100	IN
UpdateSearchItem	P	@Guid	nvarchar	200	IN
UpdateSearchItem	P	@HitCount	int	4	IN
UpdateSearchItem	P	@ImageFileId	int	4	IN
UpdateSearchItemWord	P	@SearchItemWordID	int	4	IN
UpdateSearchItemWord	P	@SearchItemID	int	4	IN
UpdateSearchItemWord	P	@SearchWordsID	int	4	IN
UpdateSearchItemWord	P	@Occurrences	int	4	IN
UpdateSearchItemWordPosition	P	@SearchItemWordPositionID	int	4	IN
UpdateSearchItemWordPosition	P	@SearchItemWordID	int	4	IN
UpdateSearchItemWordPosition	P	@ContentPosition	int	4	IN
UpdateSearchWord	P	@SearchWordsID	int	4	IN
UpdateSearchWord	P	@Word	nvarchar	100	IN
UpdateSearchWord	P	@IsCommon	bit	0	IN
UpdateSearchWord	P	@HitCount	int	4	IN
UpdateServer	P	@ServerID	int	4	IN
UpdateServer	P	@URL	nvarchar	255	IN
UpdateServer	P	@Enabled	bit	0	IN
UpdateServerActivity	P	@ServerName	nvarchar	50	IN
UpdateServerActivity	P	@IISAppName	nvarchar	200	IN
UpdateServerActivity	P	@CreatedDate	datetime	8	IN
UpdateServerActivity	P	@LastActivityDate	datetime	8	IN
UpdateSimpleTerm	P	@TermID	int	4	IN
UpdateSimpleTerm	P	@VocabularyID	int	4	IN
UpdateSimpleTerm	P	@Name	nvarchar	250	IN
UpdateSimpleTerm	P	@Description	nvarchar	2500	IN
UpdateSimpleTerm	P	@Weight	int	4	IN
UpdateSimpleTerm	P	@LastModifiedByUserID	int	4	IN
UpdateSkin	P	@SkinID	int	4	IN
UpdateSkin	P	@SkinSrc	nvarchar	200	IN
UpdateSkinControl	P	@SkinControlID	int	4	IN
UpdateSkinControl	P	@PackageID	int	4	IN
UpdateSkinControl	P	@ControlKey	nvarchar	50	IN
UpdateSkinControl	P	@ControlSrc	nvarchar	256	IN
UpdateSkinControl	P	@SupportsPartialRendering	bit	0	IN
UpdateSkinControl	P	@LastModifiedByUserID	int	4	IN
UpdateSkinPackage	P	@SkinPackageID	int	4	IN
UpdateSkinPackage	P	@PackageID	int	4	IN
UpdateSkinPackage	P	@PortalID	int	4	IN
UpdateSkinPackage	P	@SkinName	nvarchar	50	IN
UpdateSkinPackage	P	@SkinType	nvarchar	20	IN
UpdateSkinPackage	P	@LastModifiedByUserID	int	4	IN
UpdateSystemMessage	P	@PortalID	int	4	IN
UpdateSystemMessage	P	@MessageName	nvarchar	50	IN
UpdateSystemMessage	P	@MessageValue	ntext	1073741823	IN
UpdateTab	P	@TabId	int	4	IN
UpdateTab	P	@ContentItemID	int	4	IN
UpdateTab	P	@PortalId	int	4	IN
UpdateTab	P	@VersionGuid	uniqueidentifier	16	IN
UpdateTab	P	@DefaultLanguageGuid	uniqueidentifier	16	IN
UpdateTab	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
UpdateTab	P	@TabName	nvarchar	50	IN
UpdateTab	P	@IsVisible	bit	0	IN
UpdateTab	P	@DisableLink	bit	0	IN
UpdateTab	P	@ParentId	int	4	IN
UpdateTab	P	@IconFile	nvarchar	100	IN
UpdateTab	P	@IconFileLarge	nvarchar	100	IN
UpdateTab	P	@Title	nvarchar	200	IN
UpdateTab	P	@Description	nvarchar	500	IN
UpdateTab	P	@KeyWords	nvarchar	500	IN
UpdateTab	P	@IsDeleted	bit	0	IN
UpdateTab	P	@Url	nvarchar	255	IN
UpdateTab	P	@SkinSrc	nvarchar	200	IN
UpdateTab	P	@ContainerSrc	nvarchar	200	IN
UpdateTab	P	@TabPath	nvarchar	255	IN
UpdateTab	P	@StartDate	datetime	8	IN
UpdateTab	P	@EndDate	datetime	8	IN
UpdateTab	P	@RefreshInterval	int	4	IN
UpdateTab	P	@PageHeadText	nvarchar	500	IN
UpdateTab	P	@IsSecure	bit	0	IN
UpdateTab	P	@PermanentRedirect	bit	0	IN
UpdateTab	P	@SiteMapPriority	float	4	IN
UpdateTab	P	@LastModifiedByUserID	int	4	IN
UpdateTab	P	@CultureCode	nvarchar	50	IN
UpdateTabModule	P	@TabModuleId	int	4	IN
UpdateTabModule	P	@TabId	int	4	IN
UpdateTabModule	P	@ModuleId	int	4	IN
UpdateTabModule	P	@ModuleTitle	nvarchar	256	IN
UpdateTabModule	P	@Header	ntext	1073741823	IN
UpdateTabModule	P	@Footer	ntext	1073741823	IN
UpdateTabModule	P	@ModuleOrder	int	4	IN
UpdateTabModule	P	@PaneName	nvarchar	50	IN
UpdateTabModule	P	@CacheTime	int	4	IN
UpdateTabModule	P	@CacheMethod	varchar	50	IN
UpdateTabModule	P	@Alignment	nvarchar	10	IN
UpdateTabModule	P	@Color	nvarchar	20	IN
UpdateTabModule	P	@Border	nvarchar	1	IN
UpdateTabModule	P	@IconFile	nvarchar	100	IN
UpdateTabModule	P	@Visibility	int	4	IN
UpdateTabModule	P	@ContainerSrc	nvarchar	200	IN
UpdateTabModule	P	@DisplayTitle	bit	0	IN
UpdateTabModule	P	@DisplayPrint	bit	0	IN
UpdateTabModule	P	@DisplaySyndicate	bit	0	IN
UpdateTabModule	P	@IsWebSlice	bit	0	IN
UpdateTabModule	P	@WebSliceTitle	nvarchar	256	IN
UpdateTabModule	P	@WebSliceExpiryDate	datetime	8	IN
UpdateTabModule	P	@WebSliceTTL	int	4	IN
UpdateTabModule	P	@VersionGuid	uniqueidentifier	16	IN
UpdateTabModule	P	@DefaultLanguageGuid	uniqueidentifier	16	IN
UpdateTabModule	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
UpdateTabModule	P	@CultureCode	nvarchar	10	IN
UpdateTabModule	P	@LastModifiedByUserID	int	4	IN
UpdateTabModuleSetting	P	@TabModuleId	int	4	IN
UpdateTabModuleSetting	P	@SettingName	nvarchar	50	IN
UpdateTabModuleSetting	P	@SettingValue	nvarchar	2000	IN
UpdateTabModuleSetting	P	@LastModifiedByUserID	int	4	IN
UpdateTabModuleTranslationStatus	P	@TabModuleId	int	4	IN
UpdateTabModuleTranslationStatus	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
UpdateTabModuleTranslationStatus	P	@LastModifiedByUserID	int	4	IN
UpdateTabModuleVersion	P	@TabModuleID	int	4	IN
UpdateTabModuleVersion	P	@VersionGuid	uniqueidentifier	16	IN
UpdateTabOrder	P	@TabId	int	4	IN
UpdateTabOrder	P	@TabOrder	int	4	IN
UpdateTabOrder	P	@Level	int	4	IN
UpdateTabOrder	P	@ParentId	int	4	IN
UpdateTabOrder	P	@TabPath	nvarchar	255	IN
UpdateTabOrder	P	@LastModifiedByUserID	int	4	IN
UpdateTabPermission	P	@TabPermissionID	int	4	IN
UpdateTabPermission	P	@TabID	int	4	IN
UpdateTabPermission	P	@PermissionID	int	4	IN
UpdateTabPermission	P	@RoleID	int	4	IN
UpdateTabPermission	P	@AllowAccess	bit	0	IN
UpdateTabPermission	P	@UserID	int	4	IN
UpdateTabPermission	P	@LastModifiedByUserID	int	4	IN
UpdateTabSetting	P	@TabID	int	4	IN
UpdateTabSetting	P	@SettingName	nvarchar	50	IN
UpdateTabSetting	P	@SettingValue	nvarchar	2000	IN
UpdateTabSetting	P	@LastModifiedByUserID	int	4	IN
UpdateTabTranslationStatus	P	@TabId	int	4	IN
UpdateTabTranslationStatus	P	@LocalizedVersionGuid	uniqueidentifier	16	IN
UpdateTabTranslationStatus	P	@LastModifiedByUserID	int	4	IN
UpdateTabVersion	P	@TabID	int	4	IN
UpdateTabVersion	P	@VersionGuid	uniqueidentifier	16	IN
UpdateUrlTracking	P	@PortalID	int	4	IN
UpdateUrlTracking	P	@Url	nvarchar	255	IN
UpdateUrlTracking	P	@LogActivity	bit	0	IN
UpdateUrlTracking	P	@TrackClicks	bit	0	IN
UpdateUrlTracking	P	@ModuleId	int	4	IN
UpdateUrlTracking	P	@NewWindow	bit	0	IN
UpdateUrlTrackingStats	P	@PortalID	int	4	IN
UpdateUrlTrackingStats	P	@Url	nvarchar	255	IN
UpdateUrlTrackingStats	P	@ModuleId	int	4	IN
UpdateUser	P	@UserID	int	4	IN
UpdateUser	P	@PortalID	int	4	IN
UpdateUser	P	@FirstName	nvarchar	50	IN
UpdateUser	P	@LastName	nvarchar	50	IN
UpdateUser	P	@Email	nvarchar	256	IN
UpdateUser	P	@DisplayName	nvarchar	100	IN
UpdateUser	P	@UpdatePassword	bit	0	IN
UpdateUser	P	@Authorised	bit	0	IN
UpdateUser	P	@RefreshRoles	bit	0	IN
UpdateUser	P	@LastIPAddress	nvarchar	50	IN
UpdateUser	P	@IsDeleted	bit	0	IN
UpdateUser	P	@LastModifiedByUserID	int	4	IN
UpdateUserProfileProperty	P	@ProfileID	int	4	IN
UpdateUserProfileProperty	P	@UserID	int	4	IN
UpdateUserProfileProperty	P	@PropertyDefinitionID	int	4	IN
UpdateUserProfileProperty	P	@PropertyValue	ntext	1073741823	IN
UpdateUserProfileProperty	P	@Visibility	int	4	IN
UpdateUserProfileProperty	P	@LastUpdatedDate	datetime	8	IN
UpdateUserRole	P	@UserRoleId	int	4	IN
UpdateUserRole	P	@EffectiveDate	datetime	8	IN
UpdateUserRole	P	@ExpiryDate	datetime	8	IN
UpdateUserRole	P	@LastModifiedByUserID	int	4	IN
UpdateVendor	P	@VendorId	int	4	IN
UpdateVendor	P	@VendorName	nvarchar	50	IN
UpdateVendor	P	@Unit	nvarchar	50	IN
UpdateVendor	P	@Street	nvarchar	50	IN
UpdateVendor	P	@City	nvarchar	50	IN
UpdateVendor	P	@Region	nvarchar	50	IN
UpdateVendor	P	@Country	nvarchar	50	IN
UpdateVendor	P	@PostalCode	nvarchar	50	IN
UpdateVendor	P	@Telephone	nvarchar	50	IN
UpdateVendor	P	@Fax	nvarchar	50	IN
UpdateVendor	P	@Cell	nvarchar	50	IN
UpdateVendor	P	@Email	nvarchar	50	IN
UpdateVendor	P	@Website	nvarchar	100	IN
UpdateVendor	P	@FirstName	nvarchar	50	IN
UpdateVendor	P	@LastName	nvarchar	50	IN
UpdateVendor	P	@UserName	nvarchar	100	IN
UpdateVendor	P	@LogoFile	nvarchar	100	IN
UpdateVendor	P	@KeyWords	text		IN
UpdateVendor	P	@Authorized	bit	0	IN
UpdateVocabulary	P	@VocabularyID	int	4	IN
UpdateVocabulary	P	@VocabularyTypeID	int	4	IN
UpdateVocabulary	P	@Name	nvarchar	250	IN
UpdateVocabulary	P	@Description	nvarchar	2500	IN
UpdateVocabulary	P	@Weight	int	4	IN
UpdateVocabulary	P	@ScopeID	int	4	IN
UpdateVocabulary	P	@ScopeTypeID	int	4	IN
UpdateVocabulary	P	@LastModifiedByUserID	int	4	IN
VerifyPortal	P	@PortalID	int	4	IN
VerifyPortalTab	P	@PortalID	int	4	IN
VerifyPortalTab	P	@TabId	int	4	IN
fn_CompareVersion	FN		int	4	OUT
fn_CompareVersion	FN	@Version	nvarchar	20	IN
fn_CompareVersion	FN	@CurrentVersion	nvarchar	20	IN
fn_GetVersion	FN		bit	0	OUT
fn_GetVersion	FN	@maj	int	4	IN
fn_GetVersion	FN	@min	int	4	IN
fn_GetVersion	FN	@bld	int	4	IN
GetElement	FN		int	4	OUT
GetElement	FN	@ord	int	4	IN
GetElement	FN	@str	varchar	8000	IN
GetElement	FN	@delim	varchar	1	IN
GetListParentKey	FN		nvarchar	2000	OUT
GetListParentKey	FN	@ParentID	int	4	IN
GetListParentKey	FN	@ListName	nvarchar	50	IN
GetListParentKey	FN	@Type	nvarchar	50	IN
GetListParentKey	FN	@Count	int	4	IN
GetProfileElement	FN		nvarchar	4000	OUT
GetProfileElement	FN	@fieldName	nvarchar	100	IN
GetProfileElement	FN	@fields	nvarchar	4000	IN
GetProfileElement	FN	@values	nvarchar	4000	IN
GetProfilePropertyDefinitionID	FN		int	4	OUT
GetProfilePropertyDefinitionID	FN	@PortalID	int	4	IN
GetProfilePropertyDefinitionID	FN	@PropertyName	nvarchar	50	IN