title: ERWIN create and use database
body: <p>Im trying to generate physical database from my logical model using ERWIN 7.</p>
  
  <p>All is well in the script that is generated automatically, there is only the problem that the model is created in the database "master" which is the default SQL Server, rather than being created in the database that I inserted along with the model.</p>
  
  <p>I cant find a way to associate my MODEL with the database im creating along with the model.</p>
  
  <p>Here is the script that ERWIN auto-generates:</p>
  
  <pre><code>&gt; CREATE DATABASE Movies go
  &gt;
  &gt; 
  &gt; 
  &gt; 
  &gt; ALTER DATABASE Movies SET  RECOVERY FULL go
  &gt; 
  &gt; 
  &gt; 
  &gt; CREATE SCHEMA fbd AUTHORIZATION dbo go
  &gt; 
  &gt; 
  &gt; 
  &gt; CREATE DEFAULT Default_Value_movies_gen   AS 1 go
  &gt; 
  &gt; 
  &gt; 
  &gt; CREATE DEFAULT Default_Value_titulo_movies    AS 'No title' go
  </code></pre>
  
  <p>BUT it should generate automatically:</p>
  
  <blockquote>
    <p>CREATE DATABASE Movies go</p>
    
    <p>// Here should be "USE Movies",to use database that ERWIN have just created</p>
    
    <p>ALTER DATABASE Movies SET  RECOVERY FULL go</p>
    
    <p>CREATE SCHEMA fbd AUTHORIZATION dbo go</p>
    
    <p>CREATE DEFAULT Default_Value_movies_gen   AS 1 go</p>
    
    <p>CREATE DEFAULT Default_Value_titulo_movies    AS 'No title' go</p>
  </blockquote>
  
  <p>Any ideas?</p>