You can't makes it "Active" or "Inactive" directly as that would mean "adding a datatype" to SQL, and you can't do that.
What you actually do it create a Statuses Table:
ID INT, IDENTITY
Status NVARCHAR(8)
And fill it with the possible statuses:
ID Status
1 Active
2 Inactive
You then add a reference to the ID column of that table in your "main" SQL table as a FOREIGN KEY.
The main table values are then prevented from being any status other than those you list in the Statuses table.
If you need the text you just use a JOIN:
SELECT m.UserName, s.Status
FROM MainTable m
JOIN Statuses s ON m.StatusID = s.ID
To change it from active to inactive, you change the value in the main table