SQL Server Reset / Update user password – SQL Server 如何重設/更新使用者密碼?

今日為自己寫一個 SQL notes
去記下如何重設/更新 使用者密碼[你要有足夠的使用者權限才可以的]

ALTER LOGIN [SQL User Name] WITH PASSWORD = '[New Password]';  

-- E.G.
ALTER LOGIN sqluser WITH PASSWORD = 'newP@ssW01D';  

hope you find it useful

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.