Collections:
"ALTER LOGIN" - Changing a Login Name in SQL Server
How To Change a Login Name in SQL Server?
✍: FYIcenter.com
If you want to change a login name, you can use the "ALTER LOGIN" statement as shown in this tutorial example:
-- Login with "sa" -- Change login name ALTER LOGIN Fyi_Login WITH NAME = Dba_Login; GO -- 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 Dba_Login 0x5EB8701EAEBAA74F86FCF5BD8E37B8C5 S SQL_LOGIN
⇒ "ALTER LOGIN" - Disabling a Login Name in SQL Server
⇐ "ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
2016-10-19, 1486🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...