Common Password

Common Password

• Shirvo

  If you are an administrator and you want to reset a user's password, then you can just execute:
  
  ALTER LOGIN user WITH PASSWORD = 'new_password'
  
  See the ALTER LOGIN topic in BOL for more info on this statement.
  
  Is this what you were looking for
  
  Laurentiu

  
  
  

• Stitchy

  Thanks Again. Yes you are right but i tried using the Statement and it does not work. I did not find anything related in BOL.
  
  Note: I am using MS SQL Server 2000. Thanks
  
  

• Rvel

  Thanks, Let me put my question right -
  
  How to change a user's password through a System SP If I only know the administrator's username and password.
  
  

• Marc Tomlinson

  In SQL Server 2000, you can use sp_password. CREATE LOGIN is new DDL available in SQL Server 2005 only. Here's the equivalent syntax using sp_password:
  
  sp_password NULL, 'new_password', 'user'
  
  You can search for "sp_password" in BOL for SQL Server 2000 for additional info on this.
  
  Thanks
  Laurentiu
  
  

• ggssu

  Thanks Lots Laurentiu.
  
  

• Fatou

  No, there is no such script that ships with SQL Server because we do not recommend setting a common password for all SQL logins.
  
  Thanks
  Laurentiu

  
  
  
• Common Password