I am facing a weird issue with SQL Server 2012.
I have a user (say
RS\sqluser) which has
Now when i run this query
Select IS_SRVROLEMEMBER('bulkadmin', 'RS\sqluser')
output is 0. But when i execute this query
I can see
RS\sqluser present in the list.
Can someone please help me understand how is the output differing or is it BUG in SQL Server 2012? (Can't be a BUG as same query with different user works fine)