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, 1221👍, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...