Change dbo login on sql 2008

I am runnign sql 2008 sp3.

The dbo user on the database Test2 has a login of mycompany\user2 and I need user2 to have its own login.

How do I change dbo's login to sa so I can have a login for user2?
LVL 1
jimmylew52Asked:
Who is Participating?
 
Anthony PerkinsCommented:
If you are asking how you set the sa user to be the owner of the database, then that would be:
ALTER AUTHORIZATION ON DATABASE::Test2 TO sa
0
 
jimmylew52Author Commented:
That has accomplished what I want. Thank yo.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.