Collections:
"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
How To Change the Password of a Login Name in SQL Server?
✍: FYIcenter.com
If a developer lost the password of his or her login name, you can reset the password with the "ALTER LOGIN" statement as shown in this tutorial example:
-- Login with sa ALTER LOGIN FYI_DBA WITH PASSWORD = 'fyicenter'; GO Command(s) completed successfully.
FYI_DBA's password is changed now. Try it with the SQLCMD tool:
C:\>SQLCMD -S LOCALHOST\SQLEXPRESS -U FYI_DBA -P fyicenter 1> QUIT
You can also use the "ALTER LOGIN" to change your own password.
Â
2016-10-20, 1049👍, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...