Changing User Passwords

Hello,
I am hoping that someone can assist me. Some users have have left and I need
to change the the passwords on a specific Databse. How can I do this?
Ever Learning Net Admin
Use Enterprise Manager - Logins or use sp_password.
HTH
JErry
"Randaddyz" <Randaddyz@.discussions.microsoft.com> wrote in message
news:D03A32CE-6944-4158-ACCC-048D3E81AB5A@.microsoft.com...
> Hello,
> I am hoping that someone can assist me. Some users have have left and I
> need
> to change the the passwords on a specific Databse. How can I do this?
> --
> Ever Learning Net Admin
|||"Randaddyz" <Randaddyz@.discussions.microsoft.com> wrote in message
news:D03A32CE-6944-4158-ACCC-048D3E81AB5A@.microsoft.com...
> Hello,
> I am hoping that someone can assist me. Some users have have left and I
> need
> to change the the passwords on a specific Databse. How can I do this?
> --
> Ever Learning Net Admin
Do you really need to change their password, or should you be removing those
user accounts.
As Jerry said, Enterprise Manager, or sp_password stored procedure will do
the trick.
Rick Sawtell
|||I need to change the password because of how are website is tied into the
username and password. This is a long story but in short bad programming that
I am working to resolve. Where in enterprise manager do I change it? I have
looked and cannot find it. The only thing it seems I can change is the
permissions from what I can see.
(I am new to SQL. I am received my MCDBA 2 years a go but then never worked
on another SQL DB. I have forgotten too much.)
Ever Learning Net Admin
"Rick Sawtell" wrote:

> "Randaddyz" <Randaddyz@.discussions.microsoft.com> wrote in message
> news:D03A32CE-6944-4158-ACCC-048D3E81AB5A@.microsoft.com...
> Do you really need to change their password, or should you be removing those
> user accounts.
> As Jerry said, Enterprise Manager, or sp_password stored procedure will do
> the trick.
> Rick Sawtell
>
>
|||Look under security, there you will see Logins. It will be at the server
level not the database level.
-- Jesse
"Randaddyz" wrote:
[vbcol=seagreen]
> I need to change the password because of how are website is tied into the
> username and password. This is a long story but in short bad programming that
> I am working to resolve. Where in enterprise manager do I change it? I have
> looked and cannot find it. The only thing it seems I can change is the
> permissions from what I can see.
> (I am new to SQL. I am received my MCDBA 2 years a go but then never worked
> on another SQL DB. I have forgotten too much.)
> --
> Ever Learning Net Admin
>
> "Rick Sawtell" wrote: