?
Solved

how to creat a database with dbo user name and sa login name?

Posted on 2003-03-25
4
Medium Priority
?
406 Views
Last Modified: 2008-02-01
I creat a databse. in users window is one user.
name: dbo login name: <none>
how to change login name to sa?
0
Comment
Question by:Ali HND
[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
4 Comments
 
LVL 43

Accepted Solution

by:
Eugene Z earned 100 total points
ID: 8202593
use stored proc - sp_changedbowner
0
 

Assisted Solution

by:dhamijap
dhamijap earned 100 total points
ID: 8203640
Only members of the sysadmin fixed server role or the owner of the current database can execute sp_changedbowner

USE 'yourdatabasename'
GO
EXEC sp_changedbowner 'sa'
0
 

Expert Comment

by:CleanupPing
ID: 9275540
a_hnd:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

770 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