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. UnknownSeptember 19, 2020 at 11:28 PM

    please send the T-Sql scripts

    ReplyDelete
  2. AnonymousSeptember 30, 2020 at 10:25 AM

    This comment has been removed by the author.

    ReplyDelete
  3. pandaNovember 21, 2020 at 12:48 AM

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

    ReplyDelete
  4. Habib.02August 16, 2021 at 6:18 AM

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

    ReplyDelete
  5. haaliNovember 20, 2021 at 5:21 AM

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

    ReplyDelete
  6. paxonep265August 17, 2022 at 9:44 AM

    Thanks For sharing!
    more

    ReplyDelete
  7. paxonep265August 19, 2022 at 9:08 AM

    thank you for Article, Amazing.
    tree trimming company

    ReplyDelete

Subscribe to: Post Comments (Atom)