Hello, i hope you can asnwer my question on dnnsoftware.com too. I would appreciate it.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the function 'dbo.FitsExtendedPropertyPermission', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_Lists', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_TabSettings', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_TabModuleSettings', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 5, Line 3
Cannot drop the view 'dbo.vw_ModuleSettings', because it does not exist or you do not have permission.
Msg 208, Level 16, State 1, Procedure dbo.GetFileFolderFunc, Line 12
Invalid object name 'dbo.Folders'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'FolderID'.
Msg 208, Level 16, State 1, Procedure dbo.AdministratorRoleId, Line 12
Invalid object name 'dbo.Portals'.
Msg 102, Level 15, State 1, Procedure dbo.GetListParentKey, Line 45
Incorrect syntax near '@ParentID'.
Msg 208, Level 16, State 1, Procedure dbo.GetProfilePropertyDefinitionID, Line 14
Invalid object name 'dbo.ProfilePropertyDefinition'.
Msg 208, Level 16, State 1, Procedure dbo.GetProfileFieldSql, Line 15
Invalid object name 'dbo.ProfilePropertyDefinition'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.Journal_ValidJournalTypesForModule, Line 12
Invalid object name 'dbo.Journal_Types'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FilePaths, Line 11
Invalid object name 'dbo.Files'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.FilePath, Line 15
Invalid object name 'dbo.vw_FilePaths'.
Msg 208, Level 16, State 1, Procedure dbo.FileSize, Line 17
Invalid object name 'dbo.vw_FilePaths'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Banners, Line 24
Invalid object name 'dbo.Banners'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Banners" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 4145, Level 15, State 1, Line 4
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 52
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 6
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 53
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.vw_MasterPortals, Line 10
Invalid object name 'dbo.Portals'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Users, Line 28
Invalid object name 'dbo.Users'.
Msg 208, Level 16, State 1, Procedure dbo.vw_Files, Line 36
Invalid object name 'dbo.Files'.
Msg 1088, Level 16, State 12, Line 3
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_Files" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_PublishedFiles, Line 36
Invalid object name 'dbo.vw_Files'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FileVersions, Line 20
Invalid object name 'dbo.FileVersions'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FileVersions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_PortalFileSpace, Line 8
Invalid object name 'dbo.Files'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_PortalFileSpace" because it does not exist or you do not have permissions.
Msg 2714, Level 16, State 3, Procedure vw_ModuleBase, Line 6
There is already an object named 'vw_ModuleBase' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 2714, Level 16, State 3, Procedure vw_ModuleTabs, Line 6
There is already an object named 'vw_ModuleTabs' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 8171, Level 16, State 2, Procedure vw_Modules, Line 63
Hint 'noexpand' on object 'dbo.vw_ModuleBase' is invalid.
Msg 2714, Level 16, State 3, Procedure vw_ModulesOnTabs, Line 6
There is already an object named 'vw_ModulesOnTabs' in the database.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 53
Incorrect syntax near the keyword 'ELSE'.
Msg 8171, Level 16, State 2, Procedure vw_TabModules, Line 62
Hint 'noexpand' on object 'dbo.vw_ModuleBase' is invalid.
Msg 208, Level 16, State 1, Procedure dbo.vw_PortalDesktopModules, Line 18
Invalid object name 'dbo.DesktopModules'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ProfileDataTypes, Line 9
Invalid object name 'dbo.Lists'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ProfileBase, Line 29
Invalid object name 'dbo.UserProfile'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ProfileBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ProfileBase" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 4
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 28
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.vw_UserProfileLookup, Line 8
Invalid object name 'dbo.UserProfile'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_UserProfileLookup" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RoleUserCount, Line 7
Invalid object name 'dbo.Roles'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_RoleUserCount" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.vw_DesktopModulePermissionBase, Line 22
Invalid object name 'dbo.DesktopModulePermission'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_DesktopModulePermissions, Line 24
Invalid object name 'dbo.vw_DesktopModulePermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderRolePermissions, Line 26
Invalid object name 'dbo.FolderPermission'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FolderRolePermissions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderUserPermissions, Line 25
Invalid object name 'dbo.FolderPermission'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_FolderUserPermissions" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_FolderPermissions, Line 25
Invalid object name 'dbo.vw_FolderRolePermissions'.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabPermissionBase, Line 23
Invalid object name 'dbo.TabPermission'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabPermissions, Line 25
Invalid object name 'dbo.vw_TabPermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissionBase, Line 21
Invalid object name 'dbo.ModulePermission'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissions, Line 26
Invalid object name 'dbo.vw_ModulePermissionBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModulePermissionTabs, Line 22
Invalid object name 'dbo.Tabs'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 208, Level 16, State 1, Procedure dbo.vw_ModuleSettings, Line 11
Invalid object name 'dbo.TabModules'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_ModuleSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabModuleSettings, Line 11
Invalid object name 'dbo.TabModules'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_TabModuleSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_TabSettings, Line 11
Invalid object name 'dbo.Tabs'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_TabSettings" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RelationBase, Line 21
Invalid object name 'dbo.Relationships'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_RelationBase" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_RelatedUsers, Line 21
Invalid object name 'dbo.vw_RelationBase'.
Msg 102, Level 15, State 1, Procedure dbo.vw_Lists, Line 17
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Procedure dbo.vw_Lists, Line 22
Incorrect syntax near the keyword 'THEN'.
Msg 102, Level 15, State 1, Procedure dbo.vw_Lists, Line 29
Incorrect syntax near 'S'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Line 35
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '('.
Msg 156, Level 15, State 1, Line 36
Incorrect syntax near the keyword 'ELSE'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_CoreMessaging_Recipients" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_CoreMessaging_Recipients" because it does not exist or you do not have permissions.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalBase, Line 26
Invalid object name 'dbo.Journal'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalBase" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalItems, Line 27
Invalid object name 'dbo.vw_JournalBase'.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalSecurity, Line 16
Invalid object name 'dbo.Journal'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalSecurity" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalTypeFilters, Line 11
Invalid object name 'dbo.Journal_Types'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalTypeFilters" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.vw_JournalComments, Line 26
Invalid object name 'dbo.Journal_Comments'.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.vw_JournalComments" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Procedure dbo.FitsExtendedPropertyPermission, Line 33
Invalid object name 'dbo.UserRoles'.
Msg 208, Level 16, State 1, Procedure dbo.FitsExtendedPropertyPermission, Line 37
Invalid object name 'dbo.vw_RelatedUsers'.
Msg 208, Level 16, State 1, Procedure dbo.MasterPortalId, Line 14
Invalid object name 'dbo.vw_MasterPortals'.
Msg 208, Level 16, State 1, Procedure dbo.GetUsersByPropertyName, Line 22
Invalid object name 'dbo.vw_Profile'.
Msg 4145, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 24
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 102, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 26
Incorrect syntax near 'PropertyValue'.
Msg 319, Level 15, State 1, Procedure dbo.UserProfileBaseGranted, Line 27
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 10
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 81
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Procedure dbo.Journal_PermittedJournalIDs, Line 19
Invalid object name 'dbo.vw_JournalSecurity'.
Msg 102, Level 15, State 1, Procedure dbo.FindBanners, Line 16
Incorrect syntax near '('.
Msg 319, Level 15, State 1, Procedure dbo.FindBanners, Line 32
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 75
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 72
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 73
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure dbo.GetModules, Line 8
Incorrect syntax near 'V'.
Msg 319, Level 15, State 1, Procedure dbo.GetModules, Line 14
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 18
Incorrect syntax near the keyword 'ELSE'.
Msg 8171, Level 16, State 2, Procedure dbo.GetExtensionUrlProviders, Line 32
Hint 'noexpand' on object 'dbo.vw_ModulesOnTabs' is invalid.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '('.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 80
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 80
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 156
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 2
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 61
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 59
Incorrect syntax near the keyword 'ELSE'.
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near '('.
Msg 156, Level 15, State 1, Line 56
Incorrect syntax near the keyword 'ELSE'.
Msg 208, Level 16, State 1, Line 10
Invalid object name 'dbo.HostSettings'.
|