Re: Sp_changepassword

Jason (Jason@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
what if the user doesn't remember their current password. can they do
anything?

Well, would you like them to? :-) Or more to the point, would you like
Jack to change the password for Jill when she has left her machine
unattended for a moment?

If a user has forgotten his password, he needs to talk with his sysadmin.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Accessing SQL Server
    ... Jack writes: ... > iam getting an errror message. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Combine record
    ... i want to combine view record into a single record. ... Jack 10 22 ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server Management Studio cant see the 2005 engine?? But can see 2000 ?!?
    ... Jack writes: ... EXISTING SQL 2000 instance and treated this as the default. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)