[SQL Server]如何激活一个账号

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 = '<enterStrongPasswordHere>' ;

GO

 
Please refer to: http://msdn.microsoft.com/en-us/library/ms188670.aspx