Creating a DataBase HELP - SQL Server Forums

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

Creating a DataBase HELP

Author

Topic

dbserver2000
Starting Member

47 Posts

Posted - 2008-11-18 : 18:07:17

hello,

I am following the MS SQL Server 2005, Implementation and Maintenance, Self Paced Training Kit book.

In the example of Configuring database File and Filegroups,
I did not find a hint or warning if I use Caps Lock or not,

example, Does it make a difference if I enter :
CREATE DATABASE Sales <<< like this,
opposed to all in lower case >>>> create database sales ?

Also, after I have typed all the information, should I save, or save as or what?

I am surprised that I do not have any instructions for my inquiry in the book.

One more, would you recommend MS self paced book or the book by Osbourne?
http://www.mhprofessional.com/product.php?cat=112&isbn=0072263210

Thanks for your kind reply and help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-18 : 18:40:39

CREATE DATABASE == create database

Case sensitivity only makes a difference for object names and only when your collation supports it.

Once you "execute" the code, it is saved to the database server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

dbserver2000
Starting Member

47 Posts

Posted - 2008-11-18 : 20:13:24

Tara,
would you recommend MS self paced book or the book by Osbourne?
http://www.mhprofessional.com/product.php?cat=112&isbn=0072263210

I did execute: got errors !

quote:
Originally posted by tkizer

CREATE DATABASE == create database

Case sensitivity only makes a difference for object names and only when your collation supports it.

Once you "execute" the code, it is saved to the database server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-19 : 13:32:42

I have no knowledge of that book.

What errors did you get?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-19 : 14:10:41

dbserver2000, are you the one who requested my email address from Bill? Why do you need my email address when you can simply get in contact with me here?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

dbserver2000
Starting Member

47 Posts

Posted - 2008-11-19 : 15:52:24

Very good, then will keep the communication here.

I am a bit confused between MS Book( MCTS Self-Paced Training Kit {Exam-70-431}- Microsoft SQL Server 2005 Implementation and Maintenance ) and others. Each one starts in a different way.
MS Book, in chapter 2, to configure Data file and Log files, it did not clearly mention to click execute, now after I did I got errors as previously mentioned, but now I have no idea where all what I have entered went to. I had to reboot, now I do not know how to retrieve it.

How can i retrieve what I have entered?

What would you recommend as a learning resource, for someone who never done this before?

I find that this MS book, is not that step by step friendly.

Thanks,
Emad

quote:
Originally posted by tkizer

dbserver2000, are you the one who requested my email address from Bill? Why do you need my email address when you can simply get in contact with me here?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-19 : 16:05:22

You should have saved your script if you wanted to use it again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

dbserver2000
Starting Member

47 Posts

Posted - 2008-11-19 : 18:04:17

Since The MS book did not specify anything about executing or saving !

What would you recommend as a learning tool or resource.

quote:
Originally posted by tkizer

You should have saved your script if you wanted to use it again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources