The database principal owns a service in the database, and cannot be dropped

Expert User Verified

When dropping a user from a database, sometimes they own a table or a schema, and you can go drop them.

select dp.name, s.*
from sys.services s
inner join sys.database_principals dp on s.principal_id = dp.principal_id

To change the owner to dbo, run the following:
ALTER AUTHORIZATION ON SERVICE::Name TO dbo;

select dp.name, s.*
from sys.services s
inner join sys.database_principals dp on s.principal_id = dp.principal_id

To change the owner to dbo, run the following:
ALTER AUTHORIZATION ON SERVICE::Name TO dbo;

Comments

Leave a Comment