Home Forums SQL Server 2005 T-SQL (SS2K5) Getting IS_Member to work as expected RE: Getting IS_Member to work as expected

  • September 2, 2008 at 4:33 am

    #865913

    Sorry, Doug. I was out for the weekend so didn't see your replies.

    Hmm. BOL says that it includes database fixed roles or user-defined roles. And in testing myself added to one of our user-defined roles, I'm seeing false as the result when it should be true.

    What Service Pack are you on? I'm on SP1 at the moment. I've tried testing against SP2, but SQL won't let me add myself as an individual user to a database because I'm part of the SysAdmin domain group.

    I think this might be a bug. Have you reported it to Microsoft yet? Log into Microsoft Connect at http://connect.microsoft.com/SQLServer and then it has a features submission & bug submission page. See if it's already been submitted. If not, submit it yourself.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.