Reset SA password

I have a need to reset the SA password on our SQL 2000 SP4 Server. Only one
production database is on this server and I've confirmed with the vendor
that the database is not using the SA account for anything.
Under Security, login, I see that I can r/c on SA and change the password
there.
Is that OK to do?
What's the impact of changing the SA password?
Anything else that I'm not thinking of?
Thank you!
Randy
Hi
Take a look atv sp_password stored procedure in the BOL
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of?
> Thank you!
> Randy
|||Not sure what that means...sql n00b here...
but thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2O%23aEFqHHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi
> Take a look atv sp_password stored procedure in the BOL
>
>
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>
|||Thanks, I will use profiler to check that out.
If no one or nothing is using SA, changing the password during production
hours won't affect anything?
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>
|||I guess that I'm looking for SA in the LoginName or NTUserName Column?
I've been running it for five minutes, and never saw SA scroll by . . .
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>