Solved

Change dbo login on sql 2008

Posted on 2014-10-21
2
262 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL syntax for max(date) 3 39
database audit for object access 6 42
SQL Server 2012 and core licensing 5 32
TDE for SQL Web Edition 1 42
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

752 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