I ran the script manually, but it still returned errors regarding column names throughout. Any ideas? I removed a bunch of (0 row(s) affected) and (1 row(s) affected) for space saving but below are the results......
SQL Results from Execution
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'EditorControlSrc' in table 'dbo.dnn_test_PackageTypes' is specified more than once.
Msg 2705, Level 16, State 4, Line 6
Column names in each table must be unique. Column name 'PackageID' in table 'dbo.dnn_test_DesktopModules' is specified more than once.
Msg 2627, Level 14, State 1, Line 5
Violation of UNIQUE KEY constraint 'IX_dnn_test_Permission'. Cannot insert duplicate key in object 'dbo.dnn_test_Permission'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 44
Violation of UNIQUE KEY constraint 'IX_dnn_test_ModuleControls'. Cannot insert duplicate key in object 'dbo.dnn_test_ModuleControls'.
The statement has been terminated.
Msg 2705, Level 16, State 4, Line 11
Column names in each table must be unique. Column name 'PortalID' in table 'dbo.dnn_test_Packages' is specified more than once.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 7
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 23
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 35
Invalid column name 'PortalID'.
Msg 207, Level 16, State 1, Line 35
Invalid column name 'SkinRoot'.
Msg 207, Level 16, State 1, Line 35
Invalid column name 'SkinType'.
Msg 207, Level 16, State 1, Line 31
Invalid column name 'PortalID'.
Msg 512, Level 16, State 1, Procedure DNN360Menu_Update, Line 9
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 512, Level 16, State 1, Procedure DNN360Menu_Update, Line 9
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 2705, Level 16, State 4, Line 5
Column names in each table must be unique. Column name 'IsWebSlice' in table 'dbo.dnn_test_TabModules' is specified more than once.
Msg 3728, Level 16, State 1, Line 5
'PK_EventLogMaster' is not a constraint.
Msg 3727, Level 16, State 0, Line 5
Could not drop constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 5
'FK_dnn_test_EventLog_dnn_test_EventLogTypes' is not a constraint.
Msg 3727, Level 16, State 0, Line 5
Could not drop constraint. See previous errors.