How To Enable sa Login Using T-SQL In SQL Server 2008
In this article I tell you how to enable sa login in SQL Server using T-SQL.
In this article I tell you how to enable sa login in SQL Server using T-SQL.
To enable sa login, follow given steps.
Step 1
Open SQL Server Management Studio.
Step 2
In Object Explorer, connect to database engine. Open New Query window and write following code, enter password and execute.
alter login sa enable
go
alter login sa with password='<EnterPasswordHere>'
go
