Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This warning occurs when your object definition (for example, a stored procedure) references another database on the same server. The database project cannot determine whether that object will exist at runtime. Therefore, the project flags the definition as having the potential to fail if that dependency does not exist when the object is executed.
To correct this warning
- If the dependency will exist when the object is executed, you can safely ignore this warning. Otherwise, you must take steps to create the referenced object before the object that contains the reference is executed.
Example
The warning appears for the following example of a definition for a stored procedure:
CREATE PROC proc1
AS
SELECT * FROM DatabaseName.SchemaName.TableName;
RETURN 0;