How to map the database dbo to certain user login
In MS SQL Server, if you go to look at the Users in a certain Database, say db1, and you find out that the database user dbo does not have a corresponding login, you can fix this problem by using the following Stored Procedures in Query Analyzer:
use db1
go
exec sp_changedbowner ’user1’
go
This will make the login user ’user1’ your dbo for this db1 database. If you do:
use db1
go
exec sp_changedbowner ’sa’
go
This will make sa your dbo in this database db1. This is the default.
|
