views:

463

answers:

2

I'm getting the following error deploying my database in VS 2008 with a local SQL Server 2005. I deployed other databases, but this one seems to fail.

Bsg.COC.Database.dbschema(0,0)Error TSD01268: .Net SqlClient Data Provider: Msg 1803, Level 16, State 1, Line 1 The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accommodate a copy of the model database.

I did some searching and some suggestions were to disable the size attribute, but I was unable to find where to change this setting in the IDE, only in the outputted SQL query. Do you know where to find the size attribute setting?

+1  A: 

Fixed it, in the Database\Schema Objects\Database Level Objects\Storage\Files\DATABASENAME.sqlfile.sql file, the setting is "size=??", if you just change that to a lower number it will deploy just fine.

dickeytk
Thinks for the info, well it only took you 10 minutes to find without this post, good work!!!
moi_meme
A: 

Thanks, it worked..

Dilli