Pls help me out with this query as
select * from master..syslogins WHERE hasaccess = 1
as it is both giving me record where hasaccess = 0 and 1
brgdsThe hasaccess column of the syslogins view is build based on the xstatus column of the sysxlogins table. If you will read carefully the design of thw view you will find the answer.|||Need help with correct SQL string rather than reference as gather fm Books online that hasaccess column is integer
Quote
hasaccess int -- 1, if login has been granted access to the server.
Unquote
hence do not still understand why it is not working ?|||Have you tried this?
select name,hasaccess from master..syslogins where hasaccess=1
I guess problem is QA - just select results in text not in grid.|||select * from sysxlogins where (xstatus&2) = 2
select * from sysxlogins where (xstatus&2) <> 2|||Trust also that's the case
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment