Microsoft KB Archive/928791

From BetaArchive Wiki
Knowledge Base


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

Article Last Modified on 12/13/2006



APPLIES TO

  • Microsoft Visual Studio 2005 Team Edition for Database Professionals



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.



Additional query words: TSD3024 TSD3021

Keywords: kbpubtypekc kberrmsg kbtshoot kbprb KB928791