This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The IsMember method returns TRUE when the user or login referenced is a member of the role identified in the Role argument.
Expression that evaluates to an object in the Applies To list.
String that identifies a Microsoft SQL Server or database role by name.
HRESULT IsMember(SQLDMO_LPCSTR szRole,
For the Login object, the Role argument specifies a server role. For the User object, a system or user-defined database role is identified by the argument.