SQLServerCentral / Administering / SQL Server 2005 / Query to Delete all User defined schemas, roles and users / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:46:57 GMT20RE: Query to Delete all User defined schemas, roles and usershttp://www.sqlservercentral.com/Forums/Topic1067181-146-1.aspxSomething like:[code="sql"]select 'drop user ' + name + ';'from sys.database_principalsWHERE type = 's';[/code]Copy-and-paste the results into a window in Management Studio, delete the ones you want to keep, and then run it.Tue, 22 Feb 2011 08:46:29 GMTGSquaredRE: Query to Delete all User defined schemas, roles and usershttp://www.sqlservercentral.com/Forums/Topic1067181-146-1.aspxHi Is there any query as such to remove all users except sa and system account users ?Tue, 22 Feb 2011 07:29:35 GMTRamSteveRE: Query to Delete all User defined schemas, roles and usershttp://www.sqlservercentral.com/Forums/Topic1067181-146-1.aspxYou could write one, using various system views, a couple of cursors, and some light-weight dynamic SQL.However, I have to question "deleting all user-defined users" in the database. That'll pretty much get rid of all user accounts except guest and sa.Mon, 21 Feb 2011 12:03:41 GMTGSquaredQuery to Delete all User defined schemas, roles and usershttp://www.sqlservercentral.com/Forums/Topic1067181-146-1.aspxHi Is there any Query to delete all User defined schemas, roles and users in database .Thanks in Advance :)Mon, 21 Feb 2011 09:57:41 GMTRamSteve