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
Â
2016-10-19, 1066👍, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...