Changing password of SQL account

Hi Freinds,
SQL 2000
How can I change the SQL acocunt password?
I have to reset password evey 15 days and I have 2000 accounts. How can I
chabge it by writting a script?
Thanks in advance,
PatThats not that much information to give you a suggestion. Where will be new
password be stored in ? Somewehre that "thing" you want to have to change
the password must get it from some source.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Patrick" <patriarck@.gmail.com> schrieb im Newsbeitrag
news:eVRXQlkWFHA.2944@.TK2MSFTNGP10.phx.gbl...
> Hi Freinds,
> SQL 2000
> How can I change the SQL acocunt password?
> I have to reset password evey 15 days and I have 2000 accounts. How can I
> chabge it by writting a script?
> Thanks in advance,
> Pat
>|||See if this helps:
http://support.microsoft.com/newsgr...n-us&sloc=en-us
AMB
"Patrick" wrote:

> Hi Freinds,
> SQL 2000
> How can I change the SQL acocunt password?
> I have to reset password evey 15 days and I have 2000 accounts. How can I
> chabge it by writting a script?
> Thanks in advance,
> Pat
>
>|||I don't know if this is an option, but it would much more simple to manage
logins using windows authentication.
"Patrick" <patriarck@.gmail.com> wrote in message
news:eVRXQlkWFHA.2944@.TK2MSFTNGP10.phx.gbl...
> Hi Freinds,
> SQL 2000
> How can I change the SQL acocunt password?
> I have to reset password evey 15 days and I have 2000 accounts. How can I
> chabge it by writting a script?
> Thanks in advance,
> Pat
>|||I agree. If you're not using Integrated Auth yet, this is the perfect time
to start looking at it. Then just set the password policy for your Windows
accounts. You'll get much greater control over password policy than with
sp_password.
"JT" <someone@.microsoft.com> wrote in message
news:eXkid4kWFHA.3320@.TK2MSFTNGP12.phx.gbl...
>I don't know if this is an option, but it would much more simple to manage
> logins using windows authentication.
> "Patrick" <patriarck@.gmail.com> wrote in message
> news:eVRXQlkWFHA.2944@.TK2MSFTNGP10.phx.gbl...
>|||One scenario where WA would't be doable is if the SQL Server accounts are
being hosted by an ISP. He did say he is managing 2000 accounts, or perhaps
he just meant the accounts are on SQL Server 2000 . . .
"Michael C#" <howsa@.boutdat.com> wrote in message
news:un71H$kWFHA.2448@.TK2MSFTNGP12.phx.gbl...
> I agree. If you're not using Integrated Auth yet, this is the perfect
time
> to start looking at it. Then just set the password policy for your
Windows
> accounts. You'll get much greater control over password policy than with
> sp_password.
> "JT" <someone@.microsoft.com> wrote in message
> news:eXkid4kWFHA.3320@.TK2MSFTNGP12.phx.gbl...
manage
I
>|||True, but you wouldn't normally expect your ISP to automatically rotate your
p/w twice a month would you? Sounds more like an internal corporate policy
to me. You're right though - another situation might be if they're querying
SQL Server remotely from a Unix box.
"JT" <someone@.microsoft.com> wrote in message
news:ejTYpFlWFHA.1148@.tk2msftngp13.phx.gbl...
> One scenario where WA would't be doable is if the SQL Server accounts are
> being hosted by an ISP. He did say he is managing 2000 accounts, or
> perhaps
> he just meant the accounts are on SQL Server 2000 . . .
> "Michael C#" <howsa@.boutdat.com> wrote in message
> news:un71H$kWFHA.2448@.TK2MSFTNGP12.phx.gbl...
> time
> Windows
> manage
> I
>