January 13, 2010 at 10:56 pm
Hi
I have a created a SQL Server 2005 login with pw password1
Now I want reset the pw to Password2.
Could anyone tell me how to do that using SSMS and also TSQL?
Thank You
Best Regards
SQL Buddy
January 14, 2010 at 12:04 am
sqlbuddy123 (1/13/2010)
HiI have a created a SQL Server 2005 login with pw password1
Now I want reset the pw to Password2.
Could anyone tell me how to do that using SSMS and also TSQL?
Thank You
Best Regards
SQL Buddy
SSMS Example:
TSQL
sp_password 'currentPSWD', 'newPSWD'
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 14, 2010 at 9:54 am
Hi Jason,
You are always very quick and wonderful. Thank you very much for your help.
I found another method too..
ALTER LOGIN Victoria WITH
PASSWORD = 'V1cteAmanti55imE'
OLD_PASSWORD = 'B3r1000d#2-36';
GO
Thank You,
Best Regards,
SQLBuddy
January 14, 2010 at 10:11 am
It's a matter of timing.
You're welcome. Good to see that you also found an answer to your question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply