Use Short object names

[RiCOtakayama]

Hi,

what should i do to use short tablenames?

i have database and i connect with user 'hugo'

he has a table 'address'.

I want to use such a select string:
select * from address;

but i have to say:
select * from hugo.address;

is that a configuration thing?

 

[tlbroadbent]

1) The easiest way is to make DBO the owner of all objects.
2) If you logon as hugo and that login maps to a user named hugo in the database then you can reference the table by its name and leave off the owner (hugo). Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[RiCOtakayama]

dont know if i got it.

the table is owned by hugo.

i use the sql analyzer and it want me to write hugo.address

hugo is a database user.

 

[tlbroadbent]

Are you logged into SQL Server as hugo? Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[RiCOtakayama]

yeah.

used sql server login.

not domain login.

 

[tlbroadbent]

Is the login hugo a member of the system administrator role? If it is then hugo is dbo in all databsaes and must qualify table names with owner name (non-DBO owners, only) to access a table. Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[RiCOtakayama]

thanks that it was )