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

This article has been archived. It is offered "as is" and will no longer be updated.
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.
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.
MORE INFORMATION
For more information about Transact-SQL syntax conventions, visit the following Microsoft Developer Network (MSDN) Web site:

Steps to reproduce the behavior

  1. Start Visual Studio 2005.
  2. On the File menu, click New, and then click Project.
  3. Expand Database Projects, and then click Microsoft SQL Server.
  4. Click SQL Server 2005, type Database1 in the Name box, and then click OK.
  5. In Solution Explorer, expand Schema Objects, right-click Views, click Add, and then click View.
  6. In the Name box, type View1, and then click Add.
  7. 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>;
  8. On the Build menu, click Build Database1.
TSD3024 TSD3021
Properties

Article ID: 928791 - Last Review: 12/09/2015 08:26:26 - Revision: 1.0

Microsoft Visual Studio 2005 Team Edition for Database Professionals

  • kbnosurvey kbarchive kbpubtypekc kberrmsg kbtshoot kbprb KB928791
Feedback