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
>

Changing Password

How can I assign a user the ability to change/reset password for users
assigned to one particular database only in EM. Example, Northwind is one of
the databases in my system; I want the user john to be responsible for
changing/resetting password for users with access to Northwind database only
and nothing else. Is this possible? If so, how do I do it?
Thanks
EmmaPasswords are assigned to logins which are at the server
level. And only sysadmins and securityadmins can execute
sp_password. But that's at a server level, not the database
level. So no, not if you want to restrict it to just one
database.
-Sue
On Tue, 27 Sep 2005 06:52:25 -0700, "Emma"
<Emma@.discussions.microsoft.com> wrote:

>How can I assign a user the ability to change/reset password for users
>assigned to one particular database only in EM. Example, Northwind is one o
f
>the databases in my system; I want the user john to be responsible for
>changing/resetting password for users with access to Northwind database onl
y
>and nothing else. Is this possible? If so, how do I do it?
>Thanks
>Emma

Changing Index Question

Hi All,
I'm trying to desgin a table that will reset the index depending on field
values. Example:
INDX Date1 NETID JunkField
-- -- -- --
1 05/05/05 USER1 1
2 05/05/05 USER1 1
3 05/05/05 USER1 1
1 05/05/05 USER2 1
1 05/06/05 USER2 1
Every time there is a new user NETID or the DATE1 values changes, the INDX
value should reset back to 1. Could someone provide me with a simple SQL
script. I'm new to this.
Thanks.Triggers may help you acheive this. Have a look at :-
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_create2_7eeq.htm
--
HTH
Ryan Waight, MCDBA, MCSE
"JackV" <vituja@.consumer.org> wrote in message
news:%23guTPiRgDHA.620@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I'm trying to desgin a table that will reset the index depending on field
> values. Example:
> INDX Date1 NETID JunkField
> -- -- -- --
> 1 05/05/05 USER1 1
> 2 05/05/05 USER1 1
> 3 05/05/05 USER1 1
> 1 05/05/05 USER2 1
> 1 05/06/05 USER2 1
> Every time there is a new user NETID or the DATE1 values changes, the INDX
> value should reset back to 1. Could someone provide me with a simple SQL
> script. I'm new to this.
> Thanks.
>|||Hi Ryan,
The link doesn't seem to work. Can you resend it. Thanks.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eO0gI9RgDHA.2292@.TK2MSFTNGP10.phx.gbl...
> Triggers may help you acheive this. Have a look at :-
>
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
> lref.chm::/ts_create2_7eeq.htm
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "JackV" <vituja@.consumer.org> wrote in message
> news:%23guTPiRgDHA.620@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > I'm trying to desgin a table that will reset the index depending on
field
> > values. Example:
> >
> > INDX Date1 NETID JunkField
> > -- -- -- --
> > 1 05/05/05 USER1 1
> > 2 05/05/05 USER1 1
> > 3 05/05/05 USER1 1
> > 1 05/05/05 USER2 1
> > 1 05/06/05 USER2 1
> >
> > Every time there is a new user NETID or the DATE1 values changes, the
INDX
> > value should reset back to 1. Could someone provide me with a simple
SQL
> > script. I'm new to this.
> >
> > Thanks.
> >
> >
>