SA Password change

  • Hello,

    I have a question regarding 'SA' password in sql 2000. Is is possible to change the SA password without having to reschedule the jobs on a sql 2000 server?

    Also, Can you please provide the script to change the SA password on sql 2000? Thank in advance!

  • hydbadrose (6/4/2009)


    Hello,

    I have a question regarding 'SA' password in sql 2000. Is is possible to change the SA password without having to reschedule the jobs on a sql 2000 server?

    yes

    Also, Can you please provide the script to change the SA password on sql 2000? Thank in advance!

    exec sp_password NULL, 'newsecurepassword','sa'

    ---------------------------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply