Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-01-04 : 14:31:53
|
| Hi I run this script:create database mosaikDB2use mosaikDB2but it returns this error:Msg 911, Level 16, State 1, Line 2Could not locate entry in sysdatabases for database 'mosaikDB2'. No entry found with that name. Make sure that the name is entered correctly.The problem is that I have no database called mosaikDB2.If i run only create database mosaikDB2, it works without a problempls try it: try creating any new database and using it right away u ll get an error.what should i do to avoid this.Thanks a lot. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-04 : 15:05:10
|
| Put a GO statement in between.Tara Kizer |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-01-04 : 16:14:51
|
| amazing, what does Go do amigoThanks a lot |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-01-04 : 16:16:25
|
| also what do these commands do pls:SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONMuchas gracias |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-04 : 16:19:37
|
| Please look them up in SQL Server Books Online. It is explained in there.Tara Kizer |
|
|
|
|
|
|
T-SQL cant create a database and use it right away