How to make status column active/inactive in SQL table?

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