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'
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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.