How to change SQL Server Authentication Mode?

To enable the sa login by using Transact-SQL,
execute the following statements to enable the sa password and assign a password.



ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '' ;
GO