title: Using table just after creating it: object does not exist
body: <p>I have a script in T-SQL that goes like this:</p>
  
  <pre><code>create table TableName (...)
  SET IDENTITY INSERT TableName ON
  </code></pre>
  
  <p>And on second line I get error:</p>
  
  <p>Cannot find the object "TableName" because it does not exist or you do not have permissions.</p>
  
  <p>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.</p>
  
  <p>So my question is how to make this work without using "GO" so that I can run it programmatically from my C# application.</p>