sql 2008, creating a new data base

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql 2008, creating a new data base

Author

Topic

john101sql
Starting Member

4 Posts

Posted - 2012-02-12 : 14:14:28

Hi,
I'm currently working through 70-433.

In Chapter 2 there's an exercise where

CREATE DATABASE SALES

I've created the database and that's fine.
Where is this database 'SALES'?
Other databases are seen in 'Object Explorer' such as 'Northwind'. Why doesn't 'SALES' appear in 'Object Explorer'?
Apologies if this is a stupid question, but I'm new sql 2008.

thanks

John

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-12 : 14:56:17

just disconnect and reconnect to server and see
you should see SALES

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

john101sql
Starting Member

4 Posts

Posted - 2012-02-12 : 16:04:50

I think there might be some sort of refresh issue.

At the end of chapter 2 you run a script to remove 'SALES' database.

This time when I created 'SALES', it appeared straight away in 'Object Explorer'.

Thanks for the reply

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-12 : 16:15:16

Object explorer does not auto-refresh. No need to disconnect and reconnect. Just right click the server and chose refresh.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources