The error occurred on (DNN Turbo Base Version 0.8.3 (2014-04-16)) which I ran last, the other two ran fine, no errors. See run log below;
Msg 5074, Level 16, State 1, Line 13
The object 'i2i_vw_UserRoles' is dependent on column 'PortalId'.
Msg 4922, Level 16, State 9, Line 13
ALTER TABLE ALTER COLUMN PortalId failed because one or more objects access this column.
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(11 row(s) affected)
(11 row(s) affected)
(17 row(s) affected)
(16 row(s) affected)
(16 row(s) affected)
(15 row(s) affected)
(12 row(s) affected)
(8 row(s) affected)
(6 row(s) affected)
(4 row(s) affected)
(2 row(s) affected)
(1 row(s) affected)
Msg 5074, Level 16, State 1, Line 12
The object 'i2i_vw_ModuleTabs' is dependent on column 'Header'.
Msg 5074, Level 16, State 1, Line 12
The object 'i2i_vw_ModulesOnTabs' is dependent on column 'Header'.
Msg 4922, Level 16, State 9, Line 12
ALTER TABLE ALTER COLUMN Header failed because one or more objects access this column.
Msg 5074, Level 16, State 1, Line 1
The object 'i2i_vw_ModuleTabs' is dependent on column 'Footer'.
Msg 5074, Level 16, State 1, Line 1
The object 'i2i_vw_ModulesOnTabs' is dependent on column 'Footer'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN Footer failed because one or more objects access this column.
(0 row(s) affected)
Msg 5074, Level 16, State 1, Line 5
The object 'i2i_vw_Tabs' is dependent on column 'ModuleId'.
Msg 4922, Level 16, State 9, Line 5
ALTER TABLE ALTER COLUMN ModuleId failed because one or more objects access this column.
(36 row(s) affected)
(571 row(s) affected)
Msg 515, Level 16, State 2, Line 5
Cannot insert the value NULL into column 'ModuleID', table 'i2iPortals.dbo.i2i_ContentItems'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
(752 row(s) affected)
(0 row(s) affected)
Msg 5074, Level 16, State 1, Line 3
The object 'i2i_vw_Modules' is dependent on column 'Indexed'.
Msg 5074, Level 16, State 1, Line 3
The object 'i2i_vw_Tabs' is dependent on column 'Indexed'.
Msg 5074, Level 16, State 1, Line 3
The object 'i2i_vw_TabModules' is dependent on column 'Indexed'.
Msg 4922, Level 16, State 9, Line 3
ALTER TABLE ALTER COLUMN Indexed failed because one or more objects access this column.
Msg 515, Level 16, State 2, Line 3
Cannot insert the value NULL into column 'ModuleID', table 'i2iPortals.dbo.i2i_ContentItems'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
(224 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(455 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(4 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
Msg 3729, Level 16, State 1, Line 5
Cannot DROP FUNCTION 'dbo.i2i_UserDisplayName' because it is being referenced by object 'i2i_vw_DesktopModulePermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_UserDisplayName, Line 14
There is already an object named 'i2i_UserDisplayName' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP FUNCTION 'dbo.i2i_UserName' because it is being referenced by object 'i2i_vw_DesktopModulePermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_UserName, Line 14
There is already an object named 'i2i_UserName' in the database.
Msg 3729, Level 16, State 1, Line 5
Cannot DROP FUNCTION 'dbo.i2i_UserEmail' because it is being referenced by object 'i2i_vw_Portals'.
Msg 2714, Level 16, State 3, Procedure i2i_UserEmail, Line 12
There is already an object named 'i2i_UserEmail' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP FUNCTION 'dbo.i2i_RoleName' because it is being referenced by object 'i2i_vw_DesktopModulePermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_RoleName, Line 14
There is already an object named 'i2i_RoleName' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP FUNCTION 'dbo.i2i_CoreMessaging_EmailFrequency' because it is being referenced by object 'i2i_vw_MessagesForDispatch'.
Msg 2714, Level 16, State 3, Procedure i2i_CoreMessaging_EmailFrequency, Line 18
There is already an object named 'i2i_CoreMessaging_EmailFrequency' in the database.
Msg 3729, Level 16, State 1, Line 4
Cannot DROP VIEW 'dbo.i2i_vw_DesktopModulePermissionBase' because it is being referenced by object 'i2i_vw_DesktopModulePermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_DesktopModulePermissionBase, Line 4
There is already an object named 'i2i_vw_DesktopModulePermissionBase' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP VIEW 'dbo.i2i_vw_CoreMessaging_Recipients' because it is being referenced by object 'i2i_vw_MessagesForDispatch'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_CoreMessaging_Recipients, Line 4
There is already an object named 'i2i_vw_CoreMessaging_Recipients' in the database.
Msg 3729, Level 16, State 1, Line 5
Cannot DROP VIEW 'dbo.i2i_vw_ModuleBase' because it is being referenced by object 'i2i_vw_Modules'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_ModuleBase, Line 5
There is already an object named 'i2i_vw_ModuleBase' in the database.
Msg 3729, Level 16, State 1, Line 4
Cannot DROP VIEW 'dbo.i2i_vw_ModuleTabs' because it is being referenced by object 'i2i_vw_Modules'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_ModuleTabs, Line 5
There is already an object named 'i2i_vw_ModuleTabs' in the database.
Msg 3729, Level 16, State 1, Line 5
Cannot DROP VIEW 'dbo.i2i_vw_PortalBase' because it is being referenced by object 'i2i_vw_Portals'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_PortalBase, Line 4
There is already an object named 'i2i_vw_PortalBase' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP VIEW 'dbo.i2i_vw_Portals' because it is being referenced by object 'i2i_vw_PortalsDefaultLanguage'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_Portals, Line 4
There is already an object named 'i2i_vw_Portals' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP VIEW 'dbo.i2i_vw_TabPermissionBase' because it is being referenced by object 'i2i_vw_TabPermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_TabPermissionBase, Line 4
There is already an object named 'i2i_vw_TabPermissionBase' in the database.
Msg 3729, Level 16, State 1, Line 3
Cannot DROP VIEW 'dbo.i2i_vw_TabPermissionBase' because it is being referenced by object 'i2i_vw_TabPermissions'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_TabPermissionBase, Line 5
There is already an object named 'i2i_vw_TabPermissionBase' in the database.
Msg 3729, Level 16, State 1, Line 4
Cannot DROP VIEW 'dbo.i2i_vw_MasterPortals' because it is being referenced by object 'i2i_MasterPortalId'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_MasterPortals, Line 4
There is already an object named 'i2i_vw_MasterPortals' in the database.
Msg 3729, Level 16, State 1, Line 4
Cannot DROP VIEW 'dbo.i2i_vw_ProfileBase' because it is being referenced by object 'i2i_vw_Profile'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_ProfileBase, Line 6
There is already an object named 'i2i_vw_ProfileBase' in the database.
Msg 3729, Level 16, State 1, Line 5
Cannot DROP VIEW 'dbo.i2i_vw_Profile' because it is being referenced by object 'i2i_GetUsersByPropertyName'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_Profile, Line 6
There is already an object named 'i2i_vw_Profile' in the database.
Msg 3729, Level 16, State 1, Line 4
Cannot DROP VIEW 'dbo.i2i_vw_JournalBase' because it is being referenced by object 'i2i_vw_JournalItems'.
Msg 2714, Level 16, State 3, Procedure i2i_vw_JournalBase, Line 4
There is already an object named 'i2i_vw_JournalBase' in the database.
|