Change "sa" password

[itsmarkdavies]

I need to change the "sa" password on my SQL Server 2000 Server.

Can anyone tell me any implications this may have on Stored Procedures, Jobs, DTS Packages, Logins ...etc

I have used the "sa" account as the Owner of a lot of my objects, and am worried about potential Login and permission problems when I change the password.

Thanks. itsmarkdavies@hotmail.com

 

[rajeshkanna]

hi,

Open Query Analyzer and execute the following stored procedure

sp_password @new='<>', @old='<>'

<> - Place holders

regards
Rajesh Kanna. N