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
⇒ "CREATE USER" - Creating a User Name in a Database in SQL Server
⇐ "ALTER LOGIN" - Disabling a Login Name in SQL Server
2016-10-19, 1538🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...