Select the product you need help with

You receive a warning message when you use a four-part name or a three-part name for a SQL Server 2005 database project in Visual Studio 2005 Team Edition for Database Professionals

Article ID: 928791 - View products that this article applies to.

SYMPTOMS

In Microsoft Visual Studio 2005 Team Edition for Database Professionals, you use a four-part name or a three-part name for a Microsoft SQL Server 2005 database project. When you build the SQL Server 2005 database project, you receive a warning message that resembles one of following messages:

Message 1

TSD3021: The following cross-server dependencies of <WarningObject> could not be verified: <WarningSQL>. You might not be able to deploy the project.

Message 2

TSD3024: The following cross-database dependencies of <WarningObject> could not be verified: <WarningSQL>. You might not be able to deploy the project.

Back to the top | Give Feedback

CAUSE

This behavior occurs because four-part names and three-part names are not supported for SQL Server 2005 database projects in Visual Studio 2005 Team Edition for Database Professionals.

Back to the top | Give Feedback

MORE INFORMATION

For more information about Transact-SQL syntax conventions, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms177563.aspx

(http://msdn2.microsoft.com/en-us/library/ms177563.aspx)

Steps to reproduce the behavior

Start Visual Studio 2005.
On the File menu, click New, and then click Project.
Expand Database Projects, and then click Microsoft SQL Server.
Click SQL Server 2005, type Database1 in the Name box, and then click OK.
In Solution Explorer, expand Schema Objects, right-click Views, click Add, and then click View.
In the Name box, type View1, and then click Add.
In the CREATE VIEW code, replace the SELECT statement by using a SELECT statement from a table and by using a four-part name. For example, the code should resemble the following code example.
CREATE VIEW [dbo].[View1] AS SELECT * FROM <ServerName>.<DatabaseName>.<SchemaName>.<TableName> ;
On the Build menu, click Build Database1.