Copy database wizard would fail with below error while creating views or user defined functions if the dependency lists of objects is broken.
Error:
failed with the following error: "Invalid object name 'dbo. .". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Replication setup would also fail while applying the scripts if the dependency lists of objects is broken.
Error:
The schema script 'XXX_4.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: https://help/MSSQL_REPL-2147201001
Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL20164)
Get help: https://help/MSSQL_REPL20164
Invalid object name '. (Source: MSSQLServer, Error number: 208)
Get help: https://help/208
--Refer script in below link to fix the broken dependencies on all the objects
Thanks
Karthick