December 14, 2005 at 9:40 am
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
December 14, 2005 at 10:17 pm
Looks like you are attempting to use SQL 2005 syntax (ALTER LOGIN) on SQL 2000, use sp_password, from BOL:
This example changes the password for the login Victoria from a NULL password to "B3r12-36".
EXEC sp_password NULL, 'B3r12-36', 'Victoria'
AndyDecember 15, 2005 at 12:33 am
Thanks. That was the catch. I have SQL'2000 only.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply