IS_MEMBER does not appear to work when you are querying an NT domain local group.

I am a member of a domain global group DOM_A\GlobalGroup and IS_MEMBER('DOM_A\Group1') returns 1.

The global group is itself a member of a local group in another domain,
DOM_B\LocalGroup. DOM_A and DOM_B have a trust relatioship.

However, IS_MEMBER('DOM_B\LocalGroup') returns 0.

SQL Server seems to have no problem recognising the local group as sp_grantlogin 'DOM_B\LocalGroup' worked ok.

Is this a bug?

I'm running NT4 and SQLServer 7