How to Check Login Status in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to check the status of the login in SQL Server using SQL Server management studio as well as using T-SQL Script. It also demonstrates what is SQL Server Login Deny, Grant, enable and disable options in SQL Server.

Script used in this video to Check the Status of Login

SELECT denylogin,hasaccess FROM syslogins 
WHERE name = 'Techbrothers'

Check the Status of SQL Server Login