Reset "sa" password using command prompt

It is very common that we tend to forget "sa" password of the SQL DB Server.

There is very quick way to reset the password using command prompt.

To do this open command prompt on your windows system with administrator mode and type below commands

C:\WINDOWS\system32>Osql -S SERVER-NAME -E

1> EXEC sp_password NULL,'NEW-PASSWORD','sa'

2> GO

This way you can reset any user password created for specific SQL Server instance