filmov
tv
How to delete a database USER and ROLE from SQL Server
Показать описание
How to delete a database USER and ROLE from SQL Server
Trickier than it looks.
---------
Will also show you how to fix this error:
Drop failed for Login ''. (Microsoft.SqlServer.Smo)
Could not drop login '' as the user is currently logged in. (Microsoft SQL Server, Error: 15434)
----------
Will also show you how to fix this error:
Drop failed for Login ''. (Microsoft.SqlServer.Smo)
Login '' owns one or more database(s). Change the owner of the database(s) before dropping the login. (Microsoft SQL Server, Error: 15174)
Trickier than it looks.
---------
Will also show you how to fix this error:
Drop failed for Login ''. (Microsoft.SqlServer.Smo)
Could not drop login '' as the user is currently logged in. (Microsoft SQL Server, Error: 15434)
----------
Will also show you how to fix this error:
Drop failed for Login ''. (Microsoft.SqlServer.Smo)
Login '' owns one or more database(s). Change the owner of the database(s) before dropping the login. (Microsoft SQL Server, Error: 15174)
0:03:09
0:01:37
0:01:01
0:00:24
0:00:46
0:00:56
0:00:45
0:03:38
1:42:39
0:01:07
0:00:26
0:01:31
0:03:18
0:02:19
0:00:51
0:08:09
0:00:29
0:00:42
0:00:22
0:00:59
0:02:57
0:00:52
0:00:15
0:00:34