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

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:

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.

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.