title: CREATE DATABASE using file in default path
body: <p>I want to create an SQL script that creates a database.  Right now, I have this:</p>
  
  <pre><code>CREATE DATABASE [Documents] ON  PRIMARY 
  ( NAME = N'Documents', FILENAME = N'Documents.mdf')
   LOG ON 
  ( NAME = N'Documents_log', FILENAME = N'Documents_log.ldf')
   COLLATE SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>However, this generates the following error:</p>
  
  <pre><code>Msg 5105, Level 16, State 2, Line 2
  A file activation error occurred. The physical file name 'Documents.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
  Msg 1802, Level 16, State 1, Line 2
  CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
  </code></pre>
  
  <p>I know the problem is that I did not specify fully qualified path for the filenames.  But I want to be able to run this script regardless of the directory structure of the database server.  Is there some way to use a default path?</p>