View Single Post
  #3 (permalink)  
Old February 16th, 2014, 12:36 PM
AlanWheeler AlanWheeler is offline
Authorized User
Points: 416, Level: 7
Points: 416, Level: 7 Points: 416, Level: 7 Points: 416, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 84
Thanks: 29
Thanked 2 Times in 2 Posts
Default

Hi Imar,

That was perfect. I didn't quite understand that I could type in an IP address to reach the server. So,

1) I logged in, saw the tremendous list of everyone else's databases on that server, and found my PlanetWrox database.

2) I loaded my .sql script created according to the Ch 19 'Exporting' Try-It-Out.

3) But before I clicked execute, I reviewed the script a little. The first line is 'CREATE DATABASE [PlanetWrox]... . In order to gain access to the server I had to create the database called PlanetWrox, so it already exists. Do I need to alter the script, or will it just bypass this command if it sees the database already exists?

Or, should I delete everything on the server, recreate another 'temp' database, and then run the full script and expect the server to allow me to create the PlanetWrox database from within the Server to SSMS interface?

Thanks.

Best Regards,
Alan
Reply With Quote