I probably don't completely understand the question, but from the sounds of it, you don't want a blank database, but rather a database with two tables, one of which has data. Why don't you simply create a script that does exactly what you need? CREATE DATABASE x...; CREATE TABLE [Master]...; CREATE TABLE [Transaction]...; INSERT INTO [Master]...; Another option would be to add these tables to your model database. This would then make them automatically appear in any database you create on that server. PS: I assumed the table names, but it's a very bad habit to use reserved words as table names. It can lead to all sorts of problems.