Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't Drop Schema Expand / Collapse
Author
Message
Posted Wednesday, December 8, 2010 9:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:46 PM
Points: 1, Visits: 135
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.
Post #1031982
Posted Tuesday, December 14, 2010 11:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 1:54 PM
Points: 1,432, Visits: 3,229
give ownership of the object to someone else or drop the object.



The probability of survival is inversely proportional to the angle of arrival.
Post #1034619
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse