One or more unsupported elements were found in the schema used as part of a data package. Error SQL71561: Error validating element [dbo].[store_procedure_name]: Procedure: [dbo].[store_procedure_name] has an unresolved reference to object [database_name].[dbo].[table_name] in Windows Azure.

In this article, We will discuss What is the above Error and How to resolve this Error.

Whenever, We are Restoring our database into Azure at that time this issue Will arise.

The reason behind this error is, the Stored Procedure Which we were using in the database is connecting to Some other database ([database_name]) and While database restoring it won't allow that feature to use some other database like this,

[dbo].[store_procedure_name] has an unresolved reference to object [database_name].[dbo].[table_name]

Soultion:

------------

To Resolve the error we need to remove that other database name from that Stored Procudure like this,

[database_name].[dbo].[table_name] -------> [dbo].[table_name]

After Restore done in Azure then again you can keep that [database_name] and make sure that this [database_name] exists.