title: please help me with Error 27506 Error executing SQL script
body: <p>I'm trying to create a setup file using InstallShield 2010 for my project which uses SQL Server 2008</p>
  
  <p>Everything is ok all necessary programs are being installed but when I try to install my project it will give this error</p>
  
  <blockquote>
    <p><em>Error 27506. Error executing SQL script dbName.sql Line 9<br>
    Create Database failed. some file names listed could not be created Check
    related errors (1802)</em></p>
  </blockquote>
  
  <p>I searched it says that my path in SQL script does not exist but how to make database to be created in installation folder of program itself?</p>
  
  <p>Here first few lines of my SQL script</p>
  
  <pre><code>USE [master]
  GO
  
  /****** Object:  Database [InventoryDB]    Script Date: 08/11/2012 19:01:00 ******/
  CREATE DATABASE [InventoryDB] ON  PRIMARY 
  ( NAME = N'InventoryDB', FILENAME = N'C:\Inventory\DB\InventoryDB.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
   LOG ON 
  ( NAME = N'InventoryDB_log', FILENAME = N'C:\Inventory\DB\InventoryDB_log.ldf' , SIZE = 2816KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  GO
  
  ALTER DATABASE [InventoryDB] SET COMPATIBILITY_LEVEL = 100
  GO
  </code></pre>
  
  <p>please help</p>