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

7 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. A login page having in any event two content field, client name and secret key. hotmail sign in

    ReplyDelete
  3. I read that Post and got it fine and informative. website

    ReplyDelete
  4. I have a near pay this is my page investigated everything proficiently and let me handle your appraisal. this page

    ReplyDelete