Geeks With Blogs

News My Blog has been MOVED to https://mfreidge.wordpress.com
Michael Freidgeim's OLD Blog My Blog has been MOVED to https://mfreidge.wordpress.com

I wanted to delete DotNetNuke related tables from my database, which were created during accidental instalation of DotNetNuke.(I accidentally provide connection to the wrong database) and decided to use UnInstall.SqlDataProvider script file from Providers\DataProviders\SqlDataProvider DNN 4.0.2 installation.

However there were a lot of errors when running the script, like the following

Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Announcements' because this table does not exist in database 'FILMSDSQL'.
Server: Msg 3728, Level 16, State 1, Line 1
'FK_dnn_Links_dnn_Modules' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 1
Could not drop constraint. See previous errors.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Discussion' because this table does not exist in database 'FILMSDSQL'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.dnn_Events' because this table does not exist in database 'FILMSDSQL'.

.....

There were also  a few objects that I had to delete manually using Enterprise Manager (They probably were created by individual modules).

So I've re-generate the DROP script using SQL Management Studio to delete DNN tables and Stored Procedures.Additionally I had to delete ASPNET_ membership tables,Views and SPs (see SQL script below) .
Update: I've updated the SQL with th 4.4.1 new tables and also raised DNN issue to make UnInstall.SqlDataProvider.sql up-to-date.

/************************************************************/

/*****           UnInstall.SqlDataProvider.sql          *****/

/*****                                                  *****/

/*****                                                  *****/

/***** Note: The script doesn't use DOtNetNuke parameters

 {databaseOwner} and {objectQualifier}   *****/

/*****       perform a search and replace operation     *****/

/*****      but hardcoded them to  dbo. and dnn_  *****/

 

/** Remove DotNetNuke Objects **/

 

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Affiliates_dnn_Vendors]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Affiliates] DROP CONSTRAINT [FK_dnn_Affiliates_dnn_Vendors]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Announcements_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Announcements] DROP CONSTRAINT [FK_dnn_Announcements_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_AnonymousUsers_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_AnonymousUsers] DROP CONSTRAINT [FK_dnn_AnonymousUsers_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Banner_dnn_Vendor]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Banners] DROP CONSTRAINT [FK_dnn_Banner_dnn_Vendor]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Classification_dnn_Classification]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Classification] DROP CONSTRAINT [FK_dnn_Classification_dnn_Classification]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Contacts_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Contacts] DROP CONSTRAINT [FK_dnn_Contacts_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Discussion_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Discussion] DROP CONSTRAINT [FK_dnn_Discussion_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Documents_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Documents] DROP CONSTRAINT [FK_dnn_Documents_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLog_dnn_EventLogConfig]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventLog] DROP CONSTRAINT [FK_dnn_EventLog_dnn_EventLogConfig]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLog_dnn_EventLogTypes]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventLog] DROP CONSTRAINT [FK_dnn_EventLog_dnn_EventLogTypes]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventLogConfig_dnn_EventLogTypes]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventLogConfig] DROP CONSTRAINT [FK_dnn_EventLogConfig_dnn_EventLogTypes]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Events_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Events] DROP CONSTRAINT [FK_dnn_Events_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FAQs_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_FAQs] DROP CONSTRAINT [FK_dnn_FAQs_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Files_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Files] DROP CONSTRAINT [FK_dnn_Files_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FolderPermission_dnn_Folders]') AND type = 'F')

ALTER TABLE [dbo].[dnn_FolderPermission] DROP CONSTRAINT [FK_dnn_FolderPermission_dnn_Folders]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_FolderPermission_dnn_Permission]') AND type = 'F')

ALTER TABLE [dbo].[dnn_FolderPermission] DROP CONSTRAINT [FK_dnn_FolderPermission_dnn_Permission]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Folders_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Folders] DROP CONSTRAINT [FK_dnn_Folders_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_HtmlText_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_HtmlText] DROP CONSTRAINT [FK_dnn_HtmlText_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK__dnn_Links__Modul__7712C489]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Links] DROP CONSTRAINT [FK__dnn_Links__Modul__7712C489]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleControls_dnn_ModuleDefinitions]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ModuleControls] DROP CONSTRAINT [FK_dnn_ModuleControls_dnn_ModuleDefinitions]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleDefinitions_dnn_DesktopModules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ModuleDefinitions] DROP CONSTRAINT [FK_dnn_ModuleDefinitions_dnn_DesktopModules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModulePermission_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ModulePermission] DROP CONSTRAINT [FK_dnn_ModulePermission_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModulePermission_dnn_Permission]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ModulePermission] DROP CONSTRAINT [FK_dnn_ModulePermission_dnn_Permission]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Modules_dnn_ModuleDefinitions]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Modules] DROP CONSTRAINT [FK_dnn_Modules_dnn_ModuleDefinitions]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Modules_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Modules] DROP CONSTRAINT [FK_dnn_Modules_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ModuleSettings_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ModuleSettings] DROP CONSTRAINT [FK_dnn_ModuleSettings_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalAlias_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_PortalAlias] DROP CONSTRAINT [FK_dnn_PortalAlias_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalDesktopModules_dnn_DesktopModules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_PortalDesktopModules] DROP CONSTRAINT [FK_dnn_PortalDesktopModules_dnn_DesktopModules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_PortalDesktopModules_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_PortalDesktopModules] DROP CONSTRAINT [FK_dnn_PortalDesktopModules_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Profile_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Profile] DROP CONSTRAINT [FK_dnn_Profile_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Profile_dnn_Users]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Profile] DROP CONSTRAINT [FK_dnn_Profile_dnn_Users]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Roles_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Roles] DROP CONSTRAINT [FK_dnn_Roles_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ScheduleHistory_dnn_Schedule]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ScheduleHistory] DROP CONSTRAINT [FK_dnn_ScheduleHistory_dnn_Schedule]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ScheduleItemSettings_dnn_Schedule]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ScheduleItemSettings] DROP CONSTRAINT [FK_dnn_ScheduleItemSettings_dnn_Schedule]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItem_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SearchItem] DROP CONSTRAINT [FK_dnn_SearchItem_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWord_dnn_SearchItem]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SearchItemWord] DROP CONSTRAINT [FK_dnn_SearchItemWord_dnn_SearchItem]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWord_dnn_SearchWord]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SearchItemWord] DROP CONSTRAINT [FK_dnn_SearchItemWord_dnn_SearchWord]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SearchItemWordPosition_dnn_SearchItemWord]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SearchItemWordPosition] DROP CONSTRAINT [FK_dnn_SearchItemWordPosition_dnn_SearchItemWord]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SiteLog_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SiteLog] DROP CONSTRAINT [FK_dnn_SiteLog_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Skins_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Skins] DROP CONSTRAINT [FK_dnn_Skins_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SurveyOptions_dnn_Surveys]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SurveyOptions] DROP CONSTRAINT [FK_dnn_SurveyOptions_dnn_Surveys]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Surveys_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Surveys] DROP CONSTRAINT [FK_dnn_Surveys_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_SystemMessages_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_SystemMessages] DROP CONSTRAINT [FK_dnn_SystemMessages_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModules_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_TabModules] DROP CONSTRAINT [FK_dnn_TabModules_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModules_dnn_Tabs]') AND type = 'F')

ALTER TABLE [dbo].[dnn_TabModules] DROP CONSTRAINT [FK_dnn_TabModules_dnn_Tabs]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabModuleSettings_dnn_TabModules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_TabModuleSettings] DROP CONSTRAINT [FK_dnn_TabModuleSettings_dnn_TabModules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabPermission_dnn_Permission]') AND type = 'F')

ALTER TABLE [dbo].[dnn_TabPermission] DROP CONSTRAINT [FK_dnn_TabPermission_dnn_Permission]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_TabPermission_dnn_Tabs]') AND type = 'F')

ALTER TABLE [dbo].[dnn_TabPermission] DROP CONSTRAINT [FK_dnn_TabPermission_dnn_Tabs]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Tabs_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Tabs] DROP CONSTRAINT [FK_dnn_Tabs_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Tabs_dnn_Tabs]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Tabs] DROP CONSTRAINT [FK_dnn_Tabs_dnn_Tabs]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UrlLog_dnn_UrlTracking]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UrlLog] DROP CONSTRAINT [FK_dnn_UrlLog_dnn_UrlTracking]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Urls_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Urls] DROP CONSTRAINT [FK_dnn_Urls_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UrlTracking_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UrlTracking] DROP CONSTRAINT [FK_dnn_UrlTracking_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedData_dnn_UserDefinedFields]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserDefinedData] DROP CONSTRAINT [FK_dnn_UserDefinedData_dnn_UserDefinedFields]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedData_dnn_UserDefinedRows]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserDefinedData] DROP CONSTRAINT [FK_dnn_UserDefinedData_dnn_UserDefinedRows]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedFields_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserDefinedFields] DROP CONSTRAINT [FK_dnn_UserDefinedFields_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserDefinedRows_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserDefinedRows] DROP CONSTRAINT [FK_dnn_UserDefinedRows_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserPortals_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserPortals] DROP CONSTRAINT [FK_dnn_UserPortals_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserPortals_dnn_Users]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserPortals] DROP CONSTRAINT [FK_dnn_UserPortals_dnn_Users]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserRoles_dnn_Roles]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserRoles] DROP CONSTRAINT [FK_dnn_UserRoles_dnn_Roles]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserRoles_dnn_Users]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserRoles] DROP CONSTRAINT [FK_dnn_UserRoles_dnn_Users]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UsersOnline_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UsersOnline] DROP CONSTRAINT [FK_dnn_UsersOnline_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UsersOnline_dnn_Users]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UsersOnline] DROP CONSTRAINT [FK_dnn_UsersOnline_dnn_Users]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_VendorClassification_dnn_Classification]') AND type = 'F')

ALTER TABLE [dbo].[dnn_VendorClassification] DROP CONSTRAINT [FK_dnn_VendorClassification_dnn_Classification]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_VendorClassification_dnn_Vendors]') AND type = 'F')

ALTER TABLE [dbo].[dnn_VendorClassification] DROP CONSTRAINT [FK_dnn_VendorClassification_dnn_Vendors]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Vendor_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Vendors] DROP CONSTRAINT [FK_dnn_Vendor_dnn_Portals]

GO

/******* Object:  Table [dbo].[dnn_Affiliates]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Affiliates]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Affiliates]

GO

/****** Object:  Table [dbo].[dnn_Announcements]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Announcements]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Announcements]

GO

/****** Object:  Table [dbo].[dnn_AnonymousUsers]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AnonymousUsers]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_AnonymousUsers]

GO

/****** Object:  Table [dbo].[dnn_Banners]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Banners]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Banners]

GO

/****** Object:  Table [dbo].[dnn_Classification]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Classification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Classification]

GO

/****** Object:  Table [dbo].[dnn_Contacts]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Contacts]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Contacts]

GO

/****** Object:  Table [dbo].[dnn_DesktopModules]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DesktopModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_DesktopModules]

GO

/****** Object:  Table [dbo].[dnn_Discussion]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Discussion]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Discussion]

GO

/****** Object:  Table [dbo].[dnn_Documents]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Documents]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Documents]

GO

/****** Object:  Table [dbo].[dnn_EventLog]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventLog]

GO

/****** Object:  Table [dbo].[dnn_EventLogConfig]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLogConfig]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventLogConfig]

GO

/****** Object:  Table [dbo].[dnn_EventLogTypes]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventLogTypes]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventLogTypes]

GO

 

--Added 12/2/2007 for 4.4.1

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsCategory_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventsCategory] DROP CONSTRAINT [FK_dnn_EventsCategory_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsLocation_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventsLocation] DROP CONSTRAINT [FK_dnn_EventsLocation_dnn_Portals]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsMaster_dnn_Modules]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventsMaster] DROP CONSTRAINT [FK_dnn_EventsMaster_dnn_Modules]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsNotification_dnn_Events]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventsNotification] DROP CONSTRAINT [FK_dnn_EventsNotification_dnn_Events]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_EventsSignups_dnn_Events]') AND type = 'F')

ALTER TABLE [dbo].[dnn_EventsSignups] DROP CONSTRAINT [FK_dnn_EventsSignups_dnn_Events]

GO

/****** Object:  Table [dbo].[dnn_EventsCategory]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsCategory]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsCategory]

GO

/****** Object:  Table [dbo].[dnn_EventsLocation]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsLocation]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsLocation]

GO

/****** Object:  Table [dbo].[dnn_EventsMaster]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsMaster]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsMaster]

GO

/****** Object:  Table [dbo].[dnn_EventsNotification]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsNotification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsNotification]

GO

/****** Object:  Table [dbo].[dnn_EventsPPErrorLog]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsPPErrorLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsPPErrorLog]

GO

/****** Object:  Table [dbo].[dnn_EventsSignups]    Script Date: 02/12/2007 15:47:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_EventsSignups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_EventsSignups]

--Added 12/2/2007 for 4.4.1 end

 

 

 

 

/****** Object:  Table [dbo].[dnn_Events]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Events]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Events]

GO

/****** Object:  Table [dbo].[dnn_FAQs]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FAQs]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_FAQs]

GO

/****** Object:  Table [dbo].[dnn_Files]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Files]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Files]

GO

/****** Object:  Table [dbo].[dnn_FolderPermission]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FolderPermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_FolderPermission]

GO

/****** Object:  Table [dbo].[dnn_Folders]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Folders]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Folders]

GO

/****** Object:  Table [dbo].[dnn_HostSettings]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_HostSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_HostSettings]

GO

/****** Object:  Table [dbo].[dnn_HtmlText]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_HtmlText]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_HtmlText]

GO

/****** Object:  Table [dbo].[dnn_Links]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Links]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Links]

GO

/****** Object:  Table [dbo].[dnn_Lists]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Lists]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Lists]

GO

/****** Object:  Table [dbo].[dnn_ModuleControls]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleControls]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ModuleControls]

GO

/****** Object:  Table [dbo].[dnn_ModuleDefinitions]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleDefinitions]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ModuleDefinitions]

GO

/****** Object:  Table [dbo].[dnn_ModulePermission]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModulePermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ModulePermission]

GO

/****** Object:  Table [dbo].[dnn_Modules]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Modules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Modules]

GO

/****** Object:  Table [dbo].[dnn_ModuleSettings]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ModuleSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ModuleSettings]

GO

/****** Object:  Table [dbo].[dnn_Permission]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Permission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Permission]

GO

/****** Object:  Table [dbo].[dnn_PortalAlias]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PortalAlias]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_PortalAlias]

GO

/****** Object:  Table [dbo].[dnn_PortalDesktopModules]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PortalDesktopModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_PortalDesktopModules]

GO

 

--MNF 12/2/2007 begin

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Addresses_dnn_Store_Customers]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_Addresses] DROP CONSTRAINT [FK_dnn_Store_Addresses_dnn_Store_Customers]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_CartItems_dnn_Store_Cart]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_CartItems] DROP CONSTRAINT [FK_dnn_Store_CartItems_dnn_Store_Cart]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_CartItems_dnn_Store_Products]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_CartItems] DROP CONSTRAINT [FK_dnn_Store_CartItems_dnn_Store_Products]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_OrderDetails_dnn_Store_Orders]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_OrderDetails] DROP CONSTRAINT [FK_dnn_Store_OrderDetails_dnn_Store_Orders]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Products_dnn_Store_Categories]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_Products] DROP CONSTRAINT [FK_dnn_Store_Products_dnn_Store_Categories]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_Store_Reviews_dnn_Store_Products]') AND type = 'F')

ALTER TABLE [dbo].[dnn_Store_Reviews] DROP CONSTRAINT [FK_dnn_Store_Reviews_dnn_Store_Products]

GO

/****** Object:  Table [dbo].[dnn_Store_Addresses]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Addresses]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Addresses]

GO

/****** Object:  Table [dbo].[dnn_Store_Administration]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Administration]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Administration]

GO

/****** Object:  Table [dbo].[dnn_Store_Cart]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Cart]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Cart]

GO

/****** Object:  Table [dbo].[dnn_Store_CartItems]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_CartItems]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_CartItems]

GO

/****** Object:  Table [dbo].[dnn_Store_Categories]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Categories]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Categories]

GO

/****** Object:  Table [dbo].[dnn_Store_OrderDetails]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_OrderDetails]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_OrderDetails]

GO

/****** Object:  Table [dbo].[dnn_Store_Orders]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Orders]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Orders]

GO

/****** Object:  Table [dbo].[dnn_Store_Products]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Products]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Products]

GO

/****** Object:  Table [dbo].[dnn_Store_Reviews]    Script Date: 02/12/2007 15:55:28 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Store_Reviews]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Store_Reviews]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserProfile_dnn_ProfilePropertyDefinition]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserProfile] DROP CONSTRAINT [FK_dnn_UserProfile_dnn_ProfilePropertyDefinition]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_UserProfile_dnn_Users]') AND type = 'F')

ALTER TABLE [dbo].[dnn_UserProfile] DROP CONSTRAINT [FK_dnn_UserProfile_dnn_Users]

GO

/****** Object:  Table [dbo].[dnn_UserProfile]    Script Date: 02/12/2007 15:56:51 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserProfile]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserProfile]

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[FK_dnn_ProfilePropertyDefinition_dnn_Portals]') AND type = 'F')

ALTER TABLE [dbo].[dnn_ProfilePropertyDefinition] DROP CONSTRAINT [FK_dnn_ProfilePropertyDefinition_dnn_Portals]

GO

/****** Object:  Table [dbo].[dnn_ProfilePropertyDefinition]    Script Date: 02/12/2007 16:32:12 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ProfilePropertyDefinition]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ProfilePropertyDefinition]

GO

/****** Object:  Table [dbo].[dnn_RoleGroups]    Script Date: 02/12/2007 16:32:12 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_RoleGroups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_RoleGroups]

GO

--MNF 12/2/2007 end

 

/****** Object:  Table [dbo].[dnn_Portals]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Portals]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Portals]

GO

/****** Object:  Table [dbo].[dnn_Profile]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Profile]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Profile]

GO

/****** Object:  Table [dbo].[dnn_Roles]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Roles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Roles]

GO

/****** Object:  Table [dbo].[dnn_Schedule]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Schedule]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Schedule]

GO

/****** Object:  Table [dbo].[dnn_ScheduleHistory]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ScheduleHistory]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ScheduleHistory]

GO

/****** Object:  Table [dbo].[dnn_ScheduleItemSettings]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ScheduleItemSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_ScheduleItemSettings]

GO

/****** Object:  Table [dbo].[dnn_SearchCommonWords]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchCommonWords]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchCommonWords]

GO

/****** Object:  Table [dbo].[dnn_SearchIndexer]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchIndexer]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchIndexer]

GO

/****** Object:  Table [dbo].[dnn_SearchItem]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItem]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchItem]

GO

/****** Object:  Table [dbo].[dnn_SearchItemWord]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItemWord]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchItemWord]

GO

/****** Object:  Table [dbo].[dnn_SearchItemWordPosition]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchItemWordPosition]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchItemWordPosition]

GO

/****** Object:  Table [dbo].[dnn_SearchWord]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SearchWord]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SearchWord]

GO

/****** Object:  Table [dbo].[dnn_SiteLog]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SiteLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SiteLog]

GO

/****** Object:  Table [dbo].[dnn_Skins]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Skins]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Skins]

GO

/****** Object:  Table [dbo].[dnn_SurveyOptions]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SurveyOptions]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SurveyOptions]

GO

/****** Object:  Table [dbo].[dnn_Surveys]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Surveys]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Surveys]

GO

/****** Object:  Table [dbo].[dnn_SystemMessages]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_SystemMessages]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_SystemMessages]

GO

/****** Object:  Table [dbo].[dnn_TabModules]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabModules]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_TabModules]

GO

/****** Object:  Table [dbo].[dnn_TabModuleSettings]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabModuleSettings]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_TabModuleSettings]

GO

/****** Object:  Table [dbo].[dnn_TabPermission]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_TabPermission]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_TabPermission]

GO

/****** Object:  Table [dbo].[dnn_Tabs]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Tabs]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Tabs]

GO

/****** Object:  Table [dbo].[dnn_UrlLog]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UrlLog]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UrlLog]

GO

/****** Object:  Table [dbo].[dnn_Urls]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Urls]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Urls]

GO

/****** Object:  Table [dbo].[dnn_UrlTracking]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UrlTracking]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UrlTracking]

GO

/****** Object:  Table [dbo].[dnn_UserDefinedData]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedData]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserDefinedData]

GO

/****** Object:  Table [dbo].[dnn_UserDefinedFields]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedFields]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserDefinedFields]

GO

/****** Object:  Table [dbo].[dnn_UserDefinedRows]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserDefinedRows]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserDefinedRows]

GO

/****** Object:  Table [dbo].[dnn_UserPortals]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserPortals]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserPortals]

GO

/****** Object:  Table [dbo].[dnn_UserRoles]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UserRoles]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UserRoles]

GO

/****** Object:  Table [dbo].[dnn_Users]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Users]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Users]

GO

/****** Object:  Table [dbo].[dnn_UsersOnline]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UsersOnline]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_UsersOnline]

GO

/****** Object:  Table [dbo].[dnn_VendorClassification]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_VendorClassification]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_VendorClassification]

GO

/****** Object:  Table [dbo].[dnn_Vendors]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Vendors]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Vendors]

GO

/****** Object:  Table [dbo].[dnn_Version]    Script Date: 06/22/2006 12:48:44 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_Version]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE [dbo].[dnn_Version]

 

 

 

 

 

 

/****** Object:  StoredProcedure [dbo].[dnn_AddAffiliate]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddAnnouncement]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddBanner]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddContact]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddDesktopModule]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddDocument]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddEvent]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddEventLog]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddEventLogConfig]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddEventLogType]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddFAQ]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddFile]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddFolder]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddFolder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddFolderPermission]    Script Date: 06/22/2006 12:53:14 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddHostSetting]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddHostSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddHtmlText]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddHtmlText]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddLink]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddListEntry]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddListEntry]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddListEntry]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddMessage]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddModule]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddModuleControl]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddModuleDefinition]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddModulePermission]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddModuleSetting]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddPermission]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddPortalAlias]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddPortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddPortalDesktopModule]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddPortalDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddPortalInfo]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddPortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddPortalInfo]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddProfile]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddProfile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddRole]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSchedule]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddScheduleHistory]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSearchCommonWord]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSearchCommonWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSearchItem]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSearchItemWord]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSearchItemWordPosition]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSearchWord]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSiteLog]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSiteLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSiteLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSkin]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSkin]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSurvey]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSurveyOption]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSurveyOption]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSurveyResult]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSurveyResult]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSurveyResult]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddSystemMessage]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddTab]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddTabModule]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddTabModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddTabModuleSetting]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddTabPermission]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUrl]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUrl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUrlLog]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrlLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUrlLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUrlTracking]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUser]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUserDefinedData]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUserDefinedField]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUserDefinedRow]    Script Date: 06/22/2006 12:53:15 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUserDefinedRow]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddUserRole]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddVendor]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_AddVendorClassification]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_AddVendorClassification]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_AddVendorClassification]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteAffiliate]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteAnnouncement]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteBanner]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteContact]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteDesktopModule]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteDocument]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteEvent]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteEventLog]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteEventLogConfig]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteEventLogType]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFAQ]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFile]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFiles]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFolder]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFolder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFolderPermission]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteFolderPermissionsByFolderPath]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteFolderPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteFolderPermissionsByFolderPath]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteLink]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteList]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteList]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteListEntryByID]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteListEntryByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteListEntryByID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteMessage]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModule]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModuleControl]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModuleDefinition]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModulePermission]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModulePermissionsByModuleID]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModulePermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModulePermissionsByModuleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModuleSetting]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteModuleSettings]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeletePermission]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeletePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeletePortalAlias]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeletePortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeletePortalDesktopModules]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeletePortalDesktopModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeletePortalInfo]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeletePortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeletePortalInfo]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteRole]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSchedule]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchCommonWord]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchCommonWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchItem]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchItems]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItems]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchItems]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchItemWord]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchItemWordPosition]    Script Date: 06/22/2006 12:53:16 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchItemWords]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchItemWords]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchItemWords]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSearchWord]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSiteLog]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSiteLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSiteLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSkin]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSkin]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSurvey]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSurveyOption]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSurveyOption]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteSystemMessage]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTab]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModuleSetting]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabModuleSettings]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabPermission]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteTabPermissionsByTabID]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteTabPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteTabPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUrl]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUrl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUrlTracking]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUser]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedData]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedField]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserDefinedRow]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserDefinedRow]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserPortal]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUserRole]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteUsersOnline]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteUsersOnline]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteUsersOnline]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteVendor]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_DeleteVendorClassifications]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_DeleteVendorClassifications]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_DeleteVendorClassifications]

GO

/****** Object:  StoredProcedure [dbo].[dnn_FindBanners]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FindBanners]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_FindBanners]

GO

/****** Object:  StoredProcedure [dbo].[dnn_FindDatabaseVersion]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_FindDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_FindDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAffiliate]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAffiliates]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAffiliates]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAffiliates]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllFiles]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllFiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllModules]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllProfiles]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllProfiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllProfiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllTabs]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllTabs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllTabs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAllTabsModules]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAllTabsModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAllTabsModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAnnouncement]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetAnnouncements]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetAnnouncements]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetAnnouncements]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetBanner]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetBanners]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetBanners]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetBanners]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetContact]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetContacts]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetContacts]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetContacts]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetCurrencies]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetCurrencies]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetCurrencies]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDatabaseVersion]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDefaultLanguageByModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDefaultLanguageByModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDefaultLanguageByModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModule]    Script Date: 06/22/2006 12:53:17 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModuleByFriendlyName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModuleByFriendlyName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModuleByFriendlyName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModuleByModuleName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModuleByModuleName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModuleByModuleName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModules]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDesktopModulesByPortal]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDesktopModulesByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDesktopModulesByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDocument]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetDocuments]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetDocuments]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetDocuments]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEvent]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLog]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogByLogGUID]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogByLogGUID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogByLogGUID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogConfig]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogPendingNotif]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogPendingNotif]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogPendingNotif]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogPendingNotifConfig]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogPendingNotifConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogPendingNotifConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventLogType]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEvents]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEvents]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEvents]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetEventsByDate]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetEventsByDate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetEventsByDate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFAQ]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFAQs]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFAQs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFAQs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFile]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFileById]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFileById]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFileById]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFiles]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFiles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFiles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolderPermission]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolderPermissionsByFolderPath]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolderPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolderPermissionsByFolderPath]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetFolders]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetFolders]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetFolders]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHostSetting]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHostSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHostSettings]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHostSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHostSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetHtmlText]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetHtmlText]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetLink]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetLinks]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetLinks]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetLinks]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetList]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetList]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetList]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetListEntries]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetListEntries]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetListEntries]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetMessage]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetMessageByParentId]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetMessageByParentId]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetMessageByParentId]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModule]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleByDefinition]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleByDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleByDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControl]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControlByKeyAndSrc]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControlByKeyAndSrc]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControlByKeyAndSrc]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControls]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControls]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControls]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleControlsByKey]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleControlsByKey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleControlsByKey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinition]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinitionByName]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinitionByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinitionByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleDefinitions]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleDefinitions]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleDefinitions]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermission]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermissionsByModuleID]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermissionsByModuleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModulePermissionsByPortal]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModulePermissionsByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModulePermissionsByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModules]    Script Date: 06/22/2006 12:53:18 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleSetting]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetModuleSettings]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetOnlineUsers]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetOnlineUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetOnlineUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetOnlineUserStatistics]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetOnlineUserStatistics]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetOnlineUserStatistics]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermission]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionByCodeAndKey]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionByCodeAndKey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionByCodeAndKey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByFolderPath]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByFolderPath]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByFolderPath]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByModuleID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByModuleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByModuleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPermissionsByTabID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortal]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAlias]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAliasByPortalAliasID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAliasByPortalAliasID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAliasByPortalAliasID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalAliasByPortalID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalAliasByPortalID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalAliasByPortalID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByAlias]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByPortalAliasID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByPortalAliasID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByPortalAliasID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalByTab]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalByTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalByTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalDesktopModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalDesktopModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalDesktopModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalRoles]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalRoles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortals]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortals]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortals]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalSpaceUsed]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalSpaceUsed]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalSpaceUsed]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetPortalTabModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetPortalTabModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetPortalTabModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetProfile]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetProfile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRole]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRoleByName]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRoleByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRoleByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRoles]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRoles]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRoles]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetRolesByUser]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetRolesByUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetRolesByUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSchedule]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByEvent]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByScheduleID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByScheduleID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByScheduleID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleByTypeFullName]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleByTypeFullName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleByTypeFullName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleHistory]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleItemSettings]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleItemSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleItemSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetScheduleNextTask]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetScheduleNextTask]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetScheduleNextTask]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchCommonWordByID]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchCommonWordByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchCommonWordByID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchCommonWordsByLocale]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchCommonWordsByLocale]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchCommonWordsByLocale]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchIndexers]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchIndexers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchIndexers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItem]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItems]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItems]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItems]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordBySearchItem]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordBySearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordBySearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordBySearchWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordBySearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordBySearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordPosition]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchItemWordPositionBySearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchResultModules]    Script Date: 06/22/2006 12:53:19 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchResultModules]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchResultModules]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchResults]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchResults]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchResults]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchSettings]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchWordByID]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchWordByID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchWordByID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSearchWords]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSearchWords]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSearchWords]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetServices]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetServices]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetServices]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog1]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog1]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog1]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog12]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog12]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog12]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog2]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog2]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog2]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog3]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog3]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog3]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog4]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog4]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog4]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog5]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog5]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog5]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog6]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog6]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog6]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog7]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog7]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog7]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog8]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog8]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog8]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSiteLog9]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSiteLog9]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSiteLog9]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSkin]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSkin]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSkin]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSuperUsers]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSuperUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSuperUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurvey]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurveyOptions]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurveyOptions]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurveyOptions]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSurveys]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSurveys]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSurveys]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSystemMessage]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetSystemMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetSystemMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetSystemMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTab]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTab]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTab]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabByName]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTables]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTables]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTables]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleOrder]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleSetting]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabModuleSettings]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabModuleSettings]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabModuleSettings]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPanes]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPanes]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPanes]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermission]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermissionsByPortal]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermissionsByPortal]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermissionsByPortal]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabPermissionsByTabID]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabPermissionsByTabID]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabPermissionsByTabID]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabs]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabs]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabs]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTabsByParentId]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTabsByParentId]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTabsByParentId]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetThreadMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetThreadMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetThreadMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetTopLevelMessages]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetTopLevelMessages]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetTopLevelMessages]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrl]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrlLog]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrlLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrlLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrls]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrls]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrls]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUrlTracking]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUrlTracking]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUrlTracking]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUser]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserByUsername]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserByUsername]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserByUsername]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedData]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedData]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedField]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedField]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedField]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedFields]    Script Date: 06/22/2006 12:53:20 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedFields]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedFields]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedRow]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedRow]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedRow]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserDefinedRows]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserDefinedRows]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserDefinedRows]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserRole]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUserRolesByUsername]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUserRolesByUsername]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUserRolesByUsername]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetUsers]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetUsers]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetUsers]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendor]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendor]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendor]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorClassifications]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorClassifications]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorClassifications]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendors]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendors]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendors]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorsByEmail]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorsByEmail]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorsByEmail]

GO

/****** Object:  StoredProcedure [dbo].[dnn_GetVendorsByName]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_GetVendorsByName]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_GetVendorsByName]

GO

/****** Object:  StoredProcedure [dbo].[dnn_IsUserInRole]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_IsUserInRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_IsUserInRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItem]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItemWord]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_ListSearchItemWordPosition]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_ListSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_ListSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_PurgeEventLog]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PurgeEventLog]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_PurgeEventLog]

GO

/****** Object:  StoredProcedure [dbo].[dnn_PurgeScheduleHistory]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_PurgeScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_PurgeScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAffiliate]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAffiliate]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAffiliate]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAffiliateStats]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAffiliateStats]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAffiliateStats]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAnnouncement]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAnnouncement]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAnnouncement]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateAnonymousUser]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateAnonymousUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateAnonymousUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBanner]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBanner]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBanner]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBannerClickThrough]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBannerClickThrough]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBannerClickThrough]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateBannerViews]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateBannerViews]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateBannerViews]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateContact]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateContact]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateContact]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDatabaseVersion]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDatabaseVersion]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDatabaseVersion]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDesktopModule]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDesktopModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDesktopModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateDocument]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateDocument]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateDocument]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEvent]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEvent]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEvent]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogConfig]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogConfig]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogConfig]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogPendingNotif]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogPendingNotif]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogPendingNotif]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateEventLogType]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateEventLogType]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateEventLogType]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFAQ]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFAQ]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFAQ]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFile]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFolder]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFolder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFolder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateFolderPermission]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateFolderPermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateFolderPermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateHostSetting]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateHostSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateHostSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateHtmlText]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateHtmlText]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateHtmlText]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateLink]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateLink]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateLink]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateListEntry]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateListEntry]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateListEntry]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateListSortOrder]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateListSortOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateListSortOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateMessage]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModule]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleControl]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleControl]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleControl]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleDefinition]    Script Date: 06/22/2006 12:53:21 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleDefinition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleDefinition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleOrder]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleOrder]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleOrder]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModulePermission]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModulePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModulePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateModuleSetting]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateModuleSetting]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateModuleSetting]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateOnlineUser]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateOnlineUser]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateOnlineUser]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePermission]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePermission]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePermission]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalAlias]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalAlias]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalAlias]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalAliasOnInstall]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalAliasOnInstall]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalAliasOnInstall]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalInfo]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalInfo]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalInfo]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdatePortalSetup]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdatePortalSetup]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdatePortalSetup]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateProfile]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateProfile]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateProfile]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateRole]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateRole]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateRole]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSchedule]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSchedule]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSchedule]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateScheduleHistory]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateScheduleHistory]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateScheduleHistory]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchCommonWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchCommonWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchCommonWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItem]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItem]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItem]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItemWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItemWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItemWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchItemWordPosition]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchItemWordPosition]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchItemWordPosition]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSearchWord]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSearchWord]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSearchWord]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSurvey]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSurvey]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSurvey]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSurveyOption]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSurveyOption]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSurveyOption]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateSystemMessage]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[dnn_UpdateSystemMessage]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[dnn_UpdateSystemMessage]

GO

/****** Object:  StoredProcedure [dbo].[dnn_UpdateTab]    Script Date: 06/22/2006 12:53:22 ******/

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(