Viewing 2 posts - 1 through 2 (of 2 total)
One other idea is if you truly want all new databases to have this user with this permission per K. Brian Kelley's example, you can create this user and permission...
July 21, 2010 at 5:15 pm
#1196563
The second command is explicitly disallowed:
exec sp_revokedbaccess 'dbo'
Msg 15150, Level 16, State 1, Procedure sp_revokedbaccess, Line 51
Cannot drop the user 'dbo'.
But once you've remapped the database owner to SA, the...
April 30, 2009 at 1:53 pm
#986926