How do I specify which database to write tables to using sql script

[tango1948]

Hi I've created an SQL sript file using the Database Publishing Wizard to create schema and Data.
When I run this file in SQL Server Management Studio Express the tables are created under System Databases > Master > Tables even though I've created and selected the new database.
How do I specify the destination database when I run the SQL script.

Thanks for any help

David

 

[ptheriault]

You need a USE <database_name> statement at the top of your scripts.

USE MyDB
GO

.....

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[tango1948]

Thanks for the info Paul.
How come the Database Publishing Wizard does'nt include the name of the database in the script? Am I missing something?