Re: Other way of Changing Password if does not have Server Role

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 09/22/03 

Date: Mon, 22 Sep 2003 00:02:01 -0600

user can change its own password , but do not specify loginame parameter.
Ex:
sp_password @old = '' ,@new = 'saa'

- Vishal
"Mark Vergara" <markvergara007@hotmail.com> wrote in message
news:#SrYbVLgDHA.3024@tk2msftngp13.phx.gbl...
> Hi !
>
> This Mark Vergara Programmer from Comtech Solutions
>
> We have been creating a user login with no default server role this means
> that the user we been created has no rights to do some database task, we
try
> to login the user we been created and try to changed the password and it
> returns the error
>
> "Only members of the sysadmin role can use the loginame option. The
password
> was not changed."
>
> So is there any possibel way to change the password w/o setting the Server
> to System Administrator or to Security Administrator
>
> Can you offer any advice to me?
>
> Thanks,
>
> Mark
>
>