Backtrack:  
 
by lunarg on April 5th 2013, at 16:14

To change a user's (login's) password via Transact-SQL, use this:

ALTER LOGIN User WITH 
     PASSWORD = 'new-password' 
     OLD_PASSWORD = 'old-password';
GO
 
 
« August 2019»
SunMonTueWedThuFriSat
    123
45678910
11121314151617
18192021222324
25262728293031
 
Links
 
Quote
« I needed a password with eight characters so I picked Snow White and the Seven Dwarves. »