role_id( ‘role_name’ )
Returns the role ID for the specified role as stored in master.dbo.syssrvroles.
Example
select role_id( 'isah_replication_role' )