Re: How user can change their password with sp_password.

From: Sang Leen (sangleen_at_hotmail.com)
Date: 08/22/03 

Date: 22 Aug 2003 06:43:46 -0700

It work , I was passing the username too.

Thank you All.

uttamkp@online.microsoft.com (Uttam Parui[MS]) wrote in message news:<1euouTJaDHA.2108@cpmsftngxa06.phx.gbl>...
> I agree with Sue. Only members of the sysadmin role can change the password
> for another user?s login.
>
> If user wants to change their password then they do not need to put 'Login
> Name' in the sp_password syntax.
> They should use the foll. syntax
>
> sp_password 'oldpassword', 'Newpassword'
>
>
> HTH,
>
> Uttam Parui
> SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
> Product Support Services
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

Relevant Pages

  • Re: How user can change their password with sp_password.
    ... Only members of the sysadmin role can change the password ... If user wants to change their password then they do not need to put 'Login ... Name' in the sp_password syntax. ... SQL Server Developer Support Engineer, MCDBA, MCSE, MCT ...
    (microsoft.public.sqlserver.security)
  • Steve Perkins advice!
    ... the syntax SELECT * FROM [tablename] ... Nothing special comes wen i type it into the password and login ID(I ... dint type exactly the same thing since its the syntax, ... Just invalid password or Login appears, ...
    (alt.2600)
  • Re: Variables in SQL-script SQL2005
    ... Not all DCL commands accept variables (see BOL syntax) so you'll need to use dynamic SQL. ... DECLARE @SqlStatement nvarchar; ... N'CREATE LOGIN ' + ... DECLARE @brugernavn as char ...
    (comp.databases.ms-sqlserver)
  • Log on Table... Help!!
    ... History table with the fields autoid, username, login ... syntax at the Form_Closepropertybut it keeps giving me a syntax ... Dim sSQL As String ...
    (microsoft.public.access.forms)
  • Re: Linked Server Login Mapping - strange thing...
    ... > using OpenQuery (syntax is correct) ... > Created a mapping on Linked server security: Local Login ... > systems folks than SQL? ...
    (microsoft.public.sqlserver.security)