Q:

How is it possible in SQL Server 2005 for different users having tables with same name? 

How is it possible in SQL Server 2005 for different users having tables with the same name?  For example,if they are using server management studio.  It is possible for different users to connect to the database using server management studio,but how they can create their tables with the same table-name?  Say user1 from computer1 creates table TEST,another user from computer2 creates a different table with the name TEST again and so on in a LAN.Please help. 

A:

I think could be diferent schemas like the Example:
create schema X
create schema Y

create table X.Test (id int)
create table Y.Test (id int)

will work normally.  
The Users maybe have diferents default schema and so you can create tables with the same name.