var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query on syslogins table
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
Watch the design of syslogins view
The 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
hasaccess int -- 1, if login has been granted access to the server.
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