title: create table from another table in different database in sql server 2005
body: <p>I have a database "temp" with table "A". I created new database "temp2".
  I want to copy table "A" from "temp" to a new table in "temp2" . I tried this statement but it says I have incorrect syntax, here is the statement:</p>
  
  <pre><code>CREATE TABLE B IN 'temp2'
    AS (SELECT * FROM A IN 'temp');
  </code></pre>
  
  <p>Here is the error:</p>
  
  <p>Msg 156, Level 15, State 1, Line 2
  Incorrect syntax near the keyword 'IN'.
  Msg 156, Level 15, State 1, Line 3
  Incorrect syntax near the keyword 'IN'.</p>
  
  <p>Anyone knows whats the problem?</p>
  
  <p>Thanks in advance,</p>
  
  <p>Greg</p>