Posted by Greg D. Moore \(Strider\) on 02/28/07 16:22

"Shiller" <shillerc@gmail.com> wrote in message
news:1172678827.112925.18770@k78g2000cwa.googlegroups.com...
> On Feb 28, 10:44 am, "Massimo-Mastino" <mast...@hotmail.it> wrote:
>> Before the CREATE TABLE statements you should put this:
>>
>> USE Budget
>> go
>>
>> "Shiller" <shill...@gmail.com> ha scritto nel
>> messaggionews: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.- 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.

[Back to original message]