October 24, 2001 01:24 PM

Changing the DBO to Sa

Rating: (0)
SQL Server Magazine
InstantDoc ID #22568

When I look at Enterprise Manager or execute sp_helpdb '<db_name>' for a particular database, the database owner (DBO) appears to be a Windows NT user who hasn't been added to the SQL Server 7.0 server logins. (This NT user is a member of the local NT administrator group.) However, when I execute

USE <db_name>
EXEC sp_helpuser

the result shows that sa maps to the user DBO, which to me means that sa is the DBO. Therefore, the statement

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS