Sorry for not getting back......

Let's back up here and answer your first question

---You said -------

Hi MW,

I am impressed on your answer.

But can you please tell me one more thing,

As per you "Andromeda\Brian_Hippo" is windows user, But if you navigate the Database in Enterprise Manager, you'll find a user tab on each database. and it allows you to create a new user on this.

Then is this same with windows user or not? If not then what is the difference between the windows user and database user concepts here?

Also need clarification on the rest topics too.

Can anyone clear me on this...

Cheers!

Sandy.

-------MY REPLY follows ------

Earlier I said the login is like a ID card to enter a building.

Now just because you have an ID and enter a building, that ID does not allow you to enter every room.

Inside SQl server you have databases ( one or more ).

In ordder to visit ( or use ) these databases, your login has to have

a matching user.

What does that mean ? For each login ( like Andromeda\Brian_Hippo )

you have to create a user that goes with it.

So it's like a pair ( husband and wife ).

The following syntax will explain this properly.

CREATE USER brian_hippo FOR LOGIN "Andromeda\Brian_Hippo"

Now, that is the user that you see when you user SS.Management Studio

That's for now..

Let me explain one more topic.

What is a SCHEMA ? A schema is a logical namespace.

What does that mean ?

A schema is like a folder in windows. Allows you to organize your objects together.

( I have folders in my filing cabinet to store different types of bills.

So then , any drawer in my filing cabinet is like a database and each folder inside the drawer is a schema)

The following syntax will create a schema.

CREATE SCHEMA Shipping

To create a table inside the schema you must use the schema name infront of the object.

Ex:

USE Mydatabase; --I want to use the database that has the schema

Create table Shipping.orders

(

Name

)