Error 3729 Sql Server 2008
Contents |
here for a quick overview of the sql server cannot delete user owns schema site Help Center Detailed answers to any questions you sqlserver 3729 might have Meta Discuss the workings and policies of this site About Us cannot drop table because it is being referenced by object Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Cannot Drop Schema 'cdc' Because It Is Being Referenced By Object 'captured Columns'
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error trying to delete database user account schema drop schema in sql server up vote 4 down vote favorite I'm trying to delete a user's schema from a database and I'm getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Schema 'ext_owner'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Schema&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot drop schema 'ext_owner' because it is being referenced by object 'getroles'. (Microsoft SQL Server, Error: 3729) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=3729&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ What is the getroles object? How do I get rid of the reference so I can remove the old user account? sql-server sql-server-2005 user-accounts share|improve this question asked Dec 18 '09 at 16:53 Jason 5,6701563101 What's the command that's causing this error? Also, each user has their own schema?! Surely I misunderstan
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » Security (SS2K8) http://www.sqlservercentral.com/Forums/Topic1031982-1526-1.aspx » Can't Drop Schema Can't Drop Schema Rate Topic Display Mode Topic Options Author Message jcampbell 35659jcampbell 35659 Posted Wednesday, December 8, 2010 9:28 AM Forum Newbie Group: General Forum Members Last Login: Thursday, September 10, 2015 10:10 AM Points: 1, Visits: 166 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 sql server 3729, Level 16, State 1, Line 2Cannot 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 sturnersturner Posted Tuesday, December 14, 2010 11:42 AM UDP Broadcaster Group: General Forum Members Last Login: Friday, February 26, 2016 8:34 AM Points: 1,446, Visits: 3,250 because it is 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 » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images. Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.