sql - Using table just after creating it: object does not exist

Question

I have a script in T-SQL that goes like this:

create table TableName (...)
SET IDENTITY INSERT TableName ON

And on second line I get error:

Cannot find the object "TableName" because it does not exist or you do not have permissions.

I execute it from Management Studio 2005. When I put "GO" between these two lines, it's working. But what I would like to acomplish is not to use "GO" because I would like to place this code in my application when it will be finished.

So my question is how to make this work without using "GO" so that I can run it programmatically from my C# application.

Answer 1

Without using GO, programmatically, you would need to make 2 separate database calls.