No announcements
Found 1859814 threads
-
0 VotesThe database principal owns a service in the database, and cannot be dropped.
To troubleshoot this, I would suggest to put the profiler and try deleting use from database using SSMS.Answered | 1 Replies | 10341 Views | Created by char2000hk - Monday, November 8, 2010 4:24 AM | Last reply by Balmukund - Monday, November 8, 2010 6:14 AM
-
26 Votes
The database principal owns a schema in the database, and cannot be dropped.
The reason being is that the owner of the login has been deleted which is the Principal's schema.Answered | 11 Replies | 128584 Views | Created by Ken Grissom - Wednesday, February 15, 2006 3:44 PM | Last reply by ziaullah75 - Saturday, March 22, 2014 7:56 AM -
1 Votes
The database principal owns a schema in the database, and cannot be dropped.
Hallo Maddy, you'll find the owners of schemata with the following query: SELECT s.name, p.name FROM sys.schemas s INNER JOIN ...Answered | 2 Replies | 10676 Views | Created by maddy28 - Saturday, March 3, 2012 8:56 PM | Last reply by maddy28 - Monday, March 5, 2012 12:52 PM -
5 Votes
The database principal owns a database role and cannot be dropped.
Use the following query to determine which role is owned by the user, replacing Bob with the name of your user: SELECT DP2.name, DP1.name FROM sys.database_principals AS ...Answered | 3 Replies | 32561 Views | Created by Nadvi1 - Wednesday, January 2, 2013 4:36 PM | Last reply by Mariano Asturias - Thursday, May 26, 2016 8:58 PM -
0 Votes
The database principal owns objects in the database and cannot be dropped
Few Step(s) to Remove SQL Server Database User(s): ...Answered | 2 Replies | 3946 Views | Created by 查查 - Friday, May 3, 2013 7:53 AM | Last reply by Maggie Luo - Tuesday, May 7, 2013 9:35 AM -
2 Votes
Error: 15138 The database principal owns a schema in the database, and cannot be dropped.
Hi Satishs1206, Please execute the following query provided by Erland in this similarAnswered | 10 Replies | 26004 Views | Created by Satishs1206 - Thursday, February 11, 2016 10:21 AM | Last reply by Luis_Fernando19 - Tuesday, November 20, 2018 10:58 AM -
2 Votes
DB role unable to delete-The database principal owns a schema in the database, and cannot be dropped.
Hi ashwan, That means, you are trying to drop a user owning a schema.Answered | 2 Replies | 2859 Views | Created by ashwan - Monday, May 28, 2018 3:44 AM | Last reply by Pirlo Zhang - Monday, May 28, 2018 7:57 AM -
0 Votes
The database principal has granted or denied permissions to objects in the database and cannot be dropped
Seems the user is owner of schema and/or other object; you have to change the owner to a different DB user before you can drop it.Answered | 2 Replies | 1608 Views | Created by maksoy2099 - Thursday, September 14, 2017 2:48 PM | Last reply by Erland Sommarskog - Thursday, September 14, 2017 9:26 PM -
2 Votes
the database principal owns a service in the database -- can't drop a user
Run below code and check which service user owns.Answered | 9 Replies | 24153 Views | Created by jhcorey - Monday, June 21, 2010 7:10 PM | Last reply by Erland Sommarskog - Tuesday, August 6, 2019 9:26 PM -
0 Votes
SQL Express 2008 (the database principal owns a schema in the database, and cannot be dropped (microsoft sql server error 15138))
when i try to remove the user Test123 i cet de error: =================================== Drop failed for User 'Test123'.Answered | 1 Replies | 10288 Views | Created by armtav newbie - Friday, February 12, 2010 3:26 PM | Last reply by VS Patel - Friday, February 12, 2010 3:44 PM -
0 Votes
Cannot execute as the database principal
If you enter your database name in here the problem will go away and you can manage your database again.Answered | 3 Replies | 1022 Views | Created by TogaRudy - Tuesday, October 4, 2016 1:20 PM | Last reply by TogaRudy - Wednesday, October 5, 2016 1:22 PM -
3 Votes
DROP user fails with "The database principal has granted or denied permissions to catalog objects in the database and cannot be dropped."
This error means that the user cannot be dropped because IT granted permissions to another user that still exists.Answered | 12 Replies | 32704 Views | Created by mikea730 - Friday, September 7, 2012 10:49 PM | Last reply by Jhow31 - Wednesday, August 14, 2019 5:01 PM -
2 Votes
Msg 15138, Level 16, State 1, Line 4 The database principal owns a schema in the database, and cannot be dropped.
Supply a valid database name.Answered | 6 Replies | 11682 Views | Created by mwelizeb - Tuesday, January 3, 2012 11:11 PM | Last reply by mwelizeb - Wednesday, February 22, 2012 8:34 PM -
0 Votes
T-Logs on principal database in mirroring
-Sean The views, opinions, and posts do not reflect those of my company and are solely my own.Answered | 3 Replies | 892 Views | Created by venkatesh1985 - Tuesday, November 4, 2014 6:28 PM | Last reply by Sajal Bagchi - Thursday, November 6, 2014 9:26 AM -
0 Votes
SQL 2008 R2 restored DB to new server: "The database principal owns a schema in the database, and cannot be dropped. (.Net SqlClient Data Provider)"
Coming to the other part of your question, Yes you can't delete user that owns a schema or a role in a database.Answered | 5 Replies | 1806 Views | Created by scogordo - Wednesday, September 3, 2014 9:36 PM | Last reply by bhanu_nz - Thursday, September 4, 2014 10:16 PM -
0 Votes
I cannot drop a database
No Sql Server Agent jobs against this database.Answered | 4 Replies | 927 Views | Created by Enric Vives - Thursday, June 9, 2016 1:47 PM | Last reply by Enric Vives - Thursday, June 9, 2016 2:31 PM -
0 Votes
Restoring Database on Principal Server
Hello during database mirroing active session the restrictions as followed on Principle side- Backup of the principal database is allowed, but BACKUP LOG ...Answered | 7 Replies | 7169 Views | Created by KarthikNila - Monday, February 4, 2013 6:30 PM | Last reply by RamJaddu - Tuesday, February 5, 2013 8:44 AM -
0 Votes
Cannot drop database
Thank you Warwick, this helped to remove the database.Answered | 7 Replies | 3929 Views | Created by CasperG - Thursday, September 29, 2011 9:02 AM | Last reply by CasperG - Friday, September 30, 2011 6:55 AM -
0 Votes
Restored database: Can't drop user
I don't see this in the original database at all.Answered | 4 Replies | 8077 Views | Created by codeaholic - Monday, June 6, 2011 5:04 PM | Last reply by codeaholic - Monday, June 6, 2011 7:32 PM -
6 Votes
SSMS - cannot drop database - in use
Use the below mentioned command will drop all existing connection to your Database.Answered | 5 Replies | 11508 Views | Created by sbxotops - Wednesday, June 17, 2009 3:59 PM | Last reply by roger.breton - Sunday, March 15, 2020 6:20 PM - Items 1 to 20 of 1859814 Next ›
No announcements
