"Shiller" <sh******@gmail.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.itwrote:
>Before the CREATE TABLE statements you should put this:
USE Budget
go
"Shiller" <shill...@gmail.comha scritto nel
messaggionews:11**********************@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.- Hide quoted text -
- Show quoted text -
I tried using the USE statement, but it's not allowed in stored
procedure: "a USE database statement is not allowed in a procedure,
function or trigger."
Correct, USE is not really transact-SQL it's a control statement for query
analyzer, etc.
Off hand I'm not sure of a solution to your problem, but google may. I seem
to recall others having similar problems.
Generally though what you want to do is done by a series of scripts, not a
single stored proc.