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: Monday, November 3, 2014 11:04 AM
Points: 1, Visits: 138
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, December 11, 2014 12:22 PM
Points: 1,446, Visits: 3,232
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