By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,163 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

sql server - "use database" not found

P: 1
I am trying to script the creation of a database in sql server 2000. I have something like:

create database test

use test

create table .....etc.....

When I try to run this in the query analyzer, I get the error on the "use test" line that says:

could not location entry in sysdatabases for database 'test'. No entry found.....etc....

Can anyone tell me what I did wrong? My connection is initially bound to the master database since test does not exist. Don't I still need the use test?

May 1 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.