Changing sa password!

• DiavoloS

  SSC Journeyman

  Points: 97

  More actions

  January 15, 2005 at 4:12 am

  #102353

  Hello ppl,

  I was wondering if there is a way (like a SP or a query) to change the sa password (not via GUI)

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 15, 2005 at 9:02 am

  #537572

  sp_password can be used to change passwords. 

  sp_password @old = 'oldPassword', @new='newPassword',@loginame='sa'

   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor