Share via

TSD3022: The following cross-server dependencies could not be verified: {list}. Your database application might fail at runtime when {referencing object} is executed.

  • Article

This warning occurs when an object definition contains a reference to an object on another server. That external reference cannot be verified within the database project. An error will be generated when your database application executes the object if that external reference does not exist.

To correct this error

  • If the referenced external object will exist when the object is executed, you can safely ignore the warning.

Example

When the following procedure, which is named proc1, is executed, it will fail if the table that is referenced on an external server does not exist.

CREATE PROC proc1 
AS 
SELECT * FROM Server.Database.Schema.Table
RETURN 0;