Monday, March 19, 2012

How to change "sa" password after installation?

I just installed MS SQL SERVER2000, but seems the password I was setting didn't look good. So I want to change it, but how? Thanks!run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions|||run stored procedure using account with sysadmin role priveleges

sp_password @.new = 'newprd' , @.loginame = 'sa'

ask if you have any questions

I've figured it out, thanks!

No comments:

Post a Comment