Re: Is_Member returns 0 with SQL Server Authentication

Hi

Have you check they are a member with sp_helpgroup 'Role'

John

"AkAlan" <AkAlan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B3DB450-C278-447C-BD95-5AF1D08D7882@xxxxxxxxxxxxxxxx
I'm using Query Analyzer to determine if a user is part of a Role. I'm
using:

SELECT IS_MEMBER('SomeRole')

It returns a 1 if I am connected using Windows Authentication but 0 if
using
SQL Server authentication with a test login.
I'm absolutely sure that both logins are members of SomeRole.
Does this make sense?

Thanks for your input.



.