TSD3008: The object definition cannot have a data manipulation language (DML) statement.
This error occurs if a script file contains both a valid object definition and one or more data manipulation language (DML) statements, such as an INSERT statement.
To correct this error
- Add DML statements to a post-deployment script and remove them from the script file that contains an object definition.
Example
This error appears when you try to, for example, both create a table and populate it with data in the object definition.
CREATE TABLE T1(C1 INT);INSERT INTO T1 VALUES (10);
See Also
Tasks
How to: Modify Database Objects
How to: Specify Pre-Deployment or Post-Deployment Scripts