Name/Login Name Question

[scotidog]

In my master database I have a user

Name = dbo
Login Name = sa

Kool

In my Diamond database I have a user

Name = dbo
Login Name seems to be null

How do I make it 'sa' as well, seems there is no way of doing it by clicking on it or within the properties.

Thanks!!!

 

[tlbroadbent]

sa is the system administrator login. All system administrators are DBOs in every database. There is no need to add the login sa to the other databases. 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.