Changing Password for SA

We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition
Server. How do you change the password for SA? Do we need to do anything
before and after changing the password?
Thank you.
Diane
> How do you change the password for SA?
Read about sp_password.

> Do we need to do anything before and after changing the password?
Hopefully you don't have any applications or users connecting using this login name. If you do, you
need to handle them.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Edition Server. How do you
> change the password for SA? Do we need to do anything before and after changing the password?
> Thank you.
> Diane
>
|||ALTER LOGIN?
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard
> Edition Server. How do you change the password for SA? Do we need to do
> anything before and after changing the password?
> Thank you.
> Diane
>
|||Thank you very much for your prompt response. I guess that I need to change
the password off office hours. How do you find out what application is
using SA account? Thanks.
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
> ALTER LOGIN?
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Diane Walker" <ett9300@.yahoo.com> wrote in message
> news:OJ0wZrVmHHA.596@.TK2MSFTNGP06.phx.gbl...
>
|||You can set up a profiler run and have it trace login/out events and include
the Application Name as one of the columns. Note that profiler will have a
small impact on system performance.
TheSQLGuru
President
Indicium Resources, Inc.
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:eVgKfRWmHHA.596@.TK2MSFTNGP06.phx.gbl...
> Thank you very much for your prompt response. I guess that I need to
> change the password off office hours. How do you find out what
> application is using SA account? Thanks.
> "TheSQLGuru" <kgboles@.earthlink.net> wrote in message
> news:OopWgAWmHHA.1532@.TK2MSFTNGP03.phx.gbl...
>