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, 1642🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...