Posted by Massimo-Mastino on 02/28/07 15:44

Before the CREATE TABLE statements you should put this:

USE Budget
go



"Shiller" <shillerc@gmail.com> ha scritto nel messaggio
news:1172675843.097303.293060@8g2000cwh.googlegroups.com...
> I want my application to create a new database/tables when run for the
> first time. I have created a stored procedure to create the new
> database named "budget". When I run the stored procedure, it creates
> the budget database but the tables are created in the "master"
> database. Please help.
>

[Back to original message]