No announcements
Found 3003974 threads
-
0 VotesSQL 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 | 10380 Views | Created by armtav newbie - Friday, February 12, 2010 3:26 PM | Last reply by VS Patel - Friday, February 12, 2010 3:44 PM
-
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 | 26176 Views | Created by Satishs1206 - Thursday, February 11, 2016 10:21 AM | Last reply by Luis_Fernando19 - Tuesday, November 20, 2018 10:58 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 | 10765 Views | Created by maddy28 - Saturday, March 3, 2012 8:56 PM | Last reply by maddy28 - Monday, March 5, 2012 12:52 PM -
26 Votes
The database principal owns a schema in the database, and cannot be dropped.
So to delete the user from the table after deleting the Principal's schema is that go to the ...Answered | 11 Replies | 128836 Views | Created by Ken Grissom - Wednesday, February 15, 2006 3:44 PM | Last reply by ziaullah75 - Saturday, March 22, 2014 7:56 AM -
0 Votes
The database principal owns objects in the database and cannot be dropped
Hi, You could use the T-SQL command to get the user’s objects.Answered | 2 Replies | 4011 Views | Created by 查查 - Friday, May 3, 2013 7:53 AM | Last reply by Maggie Luo - Tuesday, May 7, 2013 9:35 AM -
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 | 33762 Views | Created by Nadvi1 - Wednesday, January 2, 2013 4:36 PM | Last reply by Mariano Asturias - Thursday, May 26, 2016 8:58 PM -
2 Votes
Msg 15138, Level 16, State 1, Line 4 The database principal owns a schema in the database, and cannot be dropped.
a Windows Account or a SQL Server account.Answered | 6 Replies | 11791 Views | Created by mwelizeb - Tuesday, January 3, 2012 11:11 PM | Last reply by mwelizeb - Wednesday, February 22, 2012 8:34 PM -
1 Votes
Cannot drop login from SQL 2012
This is the error, is there any global way to determine what in the world SQL 2012 sees this login as owning?????Answered | 6 Replies | 11358 Views | Created by Greg Fricke - Thursday, October 17, 2013 7:08 PM | Last reply by cprovolt - Saturday, February 22, 2014 2:58 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)"
For 'SQL Login' you may have to create both the login if it is missing @ Server Security and run the SID mismatch script against each database that has ...Answered | 5 Replies | 1884 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
The 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 | 10543 Views | Created by char2000hk - Monday, November 8, 2010 4:24 AM | Last reply by Balmukund - Monday, November 8, 2010 6:14 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 | 3188 Views | Created by ashwan - Monday, May 28, 2018 3:44 AM | Last reply by Pirlo Zhang - Monday, May 28, 2018 7:57 AM -
15 Votes
SSMS Cannot execute as database principal (Microsoft SQL Server, Error: 15517)
properties-->files-->select database owner-->select [sa]-- ok Please Mark it as Answered if it answered your question OR mark it as Helpful if it help ...Answered | 11 Replies | 39360 Views | Created by Geol4549 - Sunday, January 1, 2017 5:37 PM | Last reply by Can Jet - Saturday, November 17, 2018 4:57 AM -
0 Votes
Cannot execute as the database principal
Enter the correct uid & pwd and you get the same "Cannot execute as the database principal because the principal does not exist, this type of ...Answered | 3 Replies | 1202 Views | Created by TogaRudy - Tuesday, October 4, 2016 1:20 PM | Last reply by TogaRudy - Wednesday, October 5, 2016 1:22 PM -
2 Votes
Error: Database principal or schema <name> does not exist in this database.
I missed this statement "The behavior of schemas changed in SQL Server 2005.Answered | 4 Replies | 16303 Views | Created by PaulNations - Monday, November 16, 2009 4:36 PM | Last reply by PaulNations - Monday, November 16, 2009 6:43 PM -
27 Votes
can not drop user from database
error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ ...Answered | 19 Replies | 189181 Views | Created by Giuseppe Porcelli - Wednesday, October 12, 2005 9:42 AM | Last reply by HARIRAM - Wednesday, February 29, 2012 6:58 AM -
0 Votes
Transfer sql server 2008 database to sql 2005 server express
Open the SQL Server 2008 database in SQL Server Management Studio 2008.Answered | 3 Replies | 5728 Views | Created by Somya Ranjan Dash - Saturday, June 25, 2011 8:41 AM | Last reply by Peja Tao - Monday, June 27, 2011 9:01 AM -
2 Votes
sql 2008 service fails to start after applying sp3
System Databases > msdb -> Security -> Schemas and check the properties of all schemas.Answered | 12 Replies | 9373 Views | Created by Sul - Saturday, January 28, 2012 4:09 AM | Last reply by mita rances - Tuesday, June 28, 2016 7:26 AM -
0 Votes
Restored database: Can't drop user
Hello, If the database still exists in the SQL Server 2000 instance, try to change the owner of the schema to sa before ...Answered | 4 Replies | 8387 Views | Created by codeaholic - Monday, June 6, 2011 5:04 PM | Last reply by codeaholic - Monday, June 6, 2011 7:32 PM -
1 Votes
SQL server 2008 express database diagram error
Or check here for free test account for this solution: ...Answered | 4 Replies | 11712 Views | Created by PauleyHoyt - Monday, September 7, 2009 10:07 PM | Last reply by fwbbin - Tuesday, December 19, 2017 9:16 AM -
0 Votes
Cannot drop a SQL Database
Is it on your local computer (e.g. your own development SQL Server)?Answered | 6 Replies | 6021 Views | Created by Hemadribabu - Thursday, June 2, 2016 6:06 AM | Last reply by Carl G. Sopchak - Thursday, June 2, 2016 10:35 PM - Items 1 to 20 of 3003974 Next ›
No announcements
