TSD1002: The .sql file contains more than one data definition language (DDL) statement. Remove any additional statements, and retry the operation.
This error occurs if you try to put more than one data definition language (DDL) statement in an object definition.
To correct this error
- Remove the extra DDL statement from the object definition. To create multiple objects, you must put exactly one object definition in each file.
Example
This error appears if you create a table that is named T1, and in the dbo.T1.table.sql file, you specify the example DDL:
CREATE TABLE T1(c1 int);
CREATE TABLE T2(c1 int);
See Also
Tasks
How to: Modify Database Objects
How to: Create a Database Object