Article ID: 928963 - View products that this article applies to.
When you try to import a Transact-SQL script to a database project in Microsoft Visual Studio 2005 Team Edition for Database Professionals, you may receive an error message that resembles the following:
This problem occurs if the following conditions are true:
The .sql file contains more than one data definition language (DDL) statement. Remove any additional statements, and retry the operation.
This problem occurs because Visual Studio 2005 Team Edition for Database Professionals does not parse the DDL statement correctly.
To work around this problem, manually split the script into multiple statements in the script file. For example, split the script as follows:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.