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
Message 2
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
- 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.
Additional query words: TSD3024 TSD3021
Keywords: kbpubtypekc kberrmsg kbtshoot kbprb KB928791