I am trying to take the back up of “XYZ” database. One of the Stored Procedure in this database is referring to table in another database. Due to this the back up fails with below error:
Failed to backup “xyz” database with “Full” backup type: One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71562: Error validating element [dbo].[sp_nameofstoredprocdure]: Procedure: [dbo].[sp_nameofstoredprocdure] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [another_database_name].[dbo].[tablename].[columnname]. External references are not supported when creating a a package from this platform.