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, 1507🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...