DBA-dude
asked on
sp_droprolemember fails with "Cannot use the special principal 'dbo'"
I'm running on SQL 2005 (SP2) and have a database user with db_owner (see before.jpg). I would like to remove this dbo access via
USE [EktronCMS400DVL]
GO
EXEC sp_droprolemember N'db_owner', N'dbo'
GO
When I try to run this SQL, I receive the following error:
Msg 15405, Level 11, State 1, Procedure sp_droprolemember, Line 76
Cannot use the special principal 'dbo'.
before.JPG
USE [EktronCMS400DVL]
GO
EXEC sp_droprolemember N'db_owner', N'dbo'
GO
When I try to run this SQL, I receive the following error:
Msg 15405, Level 11, State 1, Procedure sp_droprolemember, Line 76
Cannot use the special principal 'dbo'.
before.JPG
you cannot drop the dbo , why do u wanna do that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.