Create database and create table

[AnnetteBean]

Hi

Hope someone can help.

I am writing a stored procedure that searchs for a database and if it doesn't exist in Master will create the database and within the same stored procedure will create the necessary tables.

Currently I am finding that because it is processing both from within the same transaction it will create the database and not the tables. Can someone please advise on whether this is possible and if so how.

Thanks

[rmiao]

Try add 'use db_name go' before 'create table' statement to switch to correct db.

[skhanal]

You have to qualify each object with databasename.ownername

[MAK]

I prefer to create .SQL scripts and execute it using OSQL or DTS package for these kind of one time DB schema creation instead of a procedure.

Procedures are used when you are often doing same set of operations again and again.