Try running sp below:-

USE [master]

GO

/****** Object: StoredProcedure [dbo].[spRoleMembers] Script Date: 04/02/2008 13:36:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spRoleMembers]

AS

/************************************************************

Creation Date: 04/28/02...