Post reply

Help!!!! I need to drop a user!

  • April 3, 2008 at 2:30 pm

    #120910

    I added a user in msdb database by accident. Now I cannot drop it because it said it owns a schema in database which is 'dbo' and I cannot find any command to drop the schema from the user.

    Please help me to delete the user!!!

  • April 3, 2008 at 2:40 pm

    #798094

    Under Schemas, change the schema owner back to the original user or role, then drop the user.

  • April 3, 2008 at 3:33 pm

    #798125

    THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply