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, 728👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...