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 translations Article translations
Article ID: 928791 - View products that this article applies to.
Expand all | Collapse all

On This Page

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:
http://msdn2.microsoft.com/en-us/library/ms177563.aspx

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.

Properties

Article ID: 928791 - Last Review: December 13, 2006 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio 2005 Team Edition for Database Professionals
Keywords: 
kbpubtypekc kberrmsg kbtshoot kbprb KB928791

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com