Enable/Disable SQL Server login

Hi,

Is there a way that I can enable/disable logins using SQL Authentication? Or similar function like Oracle's ALTER user LOCK/UNLOCK.

Thanks & Regards.
DennisYes, you can disable/enable logins using:

ALTER LOGIN login_name DISABLE

ALTER LOGIN login_name ENABLE

This works with any login, not only SQL logins.

Thanks
Laurentiu