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: