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 log
in 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.gb
l...
> We are running SQL 2000 Enterprise Edition on Windows 2003 Standard Editio
n Server. How do you
> change the password for SA? Do we need to do anything before and after ch
anging the password?
> Thank you.
> Diane
>|||Hi,
sp_password stored procedure
but read this page as well
http://support.microsoft.com/kb/322336
if any of your application using sa user/password to connect to db then ,
you need to change that application as well
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"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...
>