Re: Is_Member returns 0 with SQL Server Authentication
- From: "John Bell" <jbellnewsposts@xxxxxxxxxxx>
- Date: Sat, 4 Feb 2006 14:01:53 -0000
Have you check they are a member with sp_helpgroup 'Role'
"AkAlan" <AkAlan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
I'm using Query Analyzer to determine if a user is part of a Role. I'm
It returns a 1 if I am connected using Windows Authentication but 0 if
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.