DBO User ISSUE
Posted on 2011-02-17
I've attached a database from one server to another and the dbo user is still located at the database level but i'm unable to give the sa user access to the database because it was already located at the db level.
I am also doing transactional replication and I'm getting this error:
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517)
Anybody know a fix to this issue?