Deleting a Role in SQL Server 2005

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  November 17, 2008 at 8:08 am

  #196150

  Hi,

  I'm trying to DROP ROLE RSExecRole from the Master and MSDB System Databases. I uninstalled SQL Server Reporting Services and now I'm trying to delete all the trails left by it. When I do try to DROP the ROLE RSExecRole I get an error message which is below:

  Msg 15138, Level 16, State 1, Line 1

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

  I checked the properties of this role and I see the under the "Owned Schema's" section that is has only one box checked (well not checked but colored green) and I can not seem to uncheck(uncolor) it. How can I drop this role?

  Thanks and all help will be really appreciated.

  -Omair

  --
  :hehe:

• Slick84

  SSCertifiable

  Points: 5602

  More actions

  November 17, 2008 at 9:05 am

  #899377

  Okay.. anyway.. realised all I had to do was drop the schema first.. :rolleyes:

  --
  :hehe: