Solved

Change dbo login on sql 2008

Posted on 2014-10-21
2
256 Views
Last Modified: 2014-10-21
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?
0
Comment
Question by:jimmylew52
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 40395215
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
 
LVL 1

Author Comment

by:jimmylew52
ID: 40395257
That has accomplished what I want. Thank yo.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now