hi team,
I was looking at the article : http://msdn2.microsoft.com/en-us/library/ms174428.aspx to change the password of users without knowing the old pwd.
As per the info, it asks to use the below command :
ALTER LOGIN Victoria WITH PASSWORD = 'B3r1000d#2-36';
Go
However, I get the error message
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'LOGIN'.
Any clue ? Thanks !
Rgds, A
Get busy living ....or get busy dying....