Okay, apparently if I change databases and run any query against the new DB, then switch back and run IS_ROLEMEMBER it provides the "refresh" I need, but I would prefer a more elegant solution if anyone knows of one.