jsyers
asked on
Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)
How do you drop this user, 'VRN\kaluk'?
Error list below:
Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)
-------------------------- ----
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t.DropImpl ()
at Microsoft.SqlServer.Manage ment.Smo.U ser.Drop()
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.Dr opObjects. DoDropObje ct(Int32 objectRowIndex)
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.Dr opObjects. DropAllObj ects(Boole an stopOnError)
========================== =========
TITLE: Microsoft SQL Server Management Studio
-------------------------- ----
Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476
-------------------------- ----
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
The database principal owns an assembly and cannot be dropped. (Microsoft SQL Server, Error: 15154)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin g sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin gCollectio n sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Smo.E xecutionMa nager.Exec uteNonQuer y(StringCo llection queries)
at Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t.ExecuteN onQuery(St ringCollec tion queries, Boolean includeDbContext)
at Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t.DropImpl Worker(Urn & urn)
at Microsoft.SqlServer.Manage ment.Smo.S qlSmoObjec t.DropImpl ()
========================== =========
The database principal owns an assembly and cannot be dropped. (.Net SqlClient Data Provider)
-------------------------- ----
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476
-------------------------- ----
Server Name: dv01
Error Number: 15154
Severity: 16
State: 1
Line Number: 2
-------------------------- ----
Program Location:
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlC ommand.Run ExecuteNon QueryTds(S tring methodName, Boolean async)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (DbAsyncRe sult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin g sqlCommand, ExecutionTypes executionType)
Error list below:
Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
TITLE: Microsoft SQL Server Management Studio
--------------------------
Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476
--------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
The database principal owns an assembly and cannot be dropped. (Microsoft SQL Server, Error: 15154)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
The database principal owns an assembly and cannot be dropped. (.Net SqlClient Data Provider)
--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476
--------------------------
Server Name: dv01
Error Number: 15154
Severity: 16
State: 1
Line Number: 2
--------------------------
Program Location:
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at Microsoft.SqlServer.Manage
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is what I get:
SchemaName SchemaName
dbo dbo
guest guest
INFORMATION_SCHEMA INFORMATION_SCHEMA
sys sys
PowerCerv PowerCerv
VRN\saines VRN\aines
VRN\web VRN\web
VRN\fman VRN\fman
VRN\kaluk VRN\kaluk
VRN\nsky VRN\nsky
VRN\csek VRN\csek
db_owner db_owner
db_accessadmin db_accessadmin
db_securityadmin db_securityadmin
db_ddladmin db_ddladmin
db_backupoperator db_backupoperator
db_datareader db_datareader
db_datawriter db_datawriter
db_denydatareader db_denydatareader
db_denydatawriter db_denydatawriter
Standard User Standard User