Collections:
"DROP LOGIN" - Deleting a Login Name in SQL Server
How To Delete a Login Name in SQL Server?
✍: FYIcenter.com
If you don't want to keep a login name any more, you should delete it by using the "DROP LOGIN" statement as shown in this tutorial example:
-- Login with "sa" DROP LOGIN Dba_Login; GO Command(s) completed successfully. -- View login names SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type = 'S'; GO name sid type type_desc -------- ----------------------------------- ---- --------- sa 0x01 S SQL_LOGIN FYI_DBA 0x348AF32B3B58CB40B67A5F5B7086B96E S SQL_LOGIN
2016-10-19, 727👍, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want t...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, y...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...