Post reply

Can't Drop Schema

  • December 8, 2010 at 9:28 am

    #242379

    I'm trying to drop orphaned user and schema from a database that was copied from Dev to Production.

    Howerver, I get the error:

    Msg 3729, Level 16, State 1, Line 2

    Cannot drop schema 'DOMAIN\username' because it is being referenced by object 't_user_type_security_temp'.

    This object does not exist under dbo or the schema user name. It does still exist in sysobjects as a user table.

  • December 14, 2010 at 11:42 am

    #1262391

    give ownership of the object to someone else or drop the object.

    The probability of survival is inversely proportional to the angle of arrival.

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

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