My script can't execute alter database command SQL Server 2008

Question

I created a database then I create a procedure. When I want to alter this database, I got an error while altering this database says:

create/alter must be the first statement in a query batch

BartekR · Accepted Answer · 2012-01-15 15:25:19Z

1

If you have more than one statement to run use 'GO' command:

alter database xyz ...
GO

INSERT INTO myTable() ...
GO

etc

answered Jan 15, 2012 at 15:25

BartekR

3,9973 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1