-- Tested with SQL Server 2005 9.00.852 CREATE DATABASE DotNetFun ON PRIMARY ( NAME = 'DotNetFun_Data', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DotNetFun_Data.mdf', SIZE = 50 MB, FILEGROWTH = 10% ) LOG ON ( NAME = 'DotNetFun_Log', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DotNetFun_Log.ldf', SIZE = 10 MB, FILEGROWTH = 10% )