CREATE PROCEDURE sp_addrolemember
	@rolename       sysname,
	@membername     sysname
AS
     -- SETUP RUNTIME OPTIONS / DECLARE VARIABLES --
 
	set nocount on
	declare @roluid     smallint,
            @owner      smallint,
            @memuid     smallint,
            @ret        int
    declare @ruidbyte   smallint,
            @ruidbit    smallint
	declare @proc		nvarchar( 50 )

     -- DISALLOW USER TRANSACTION --
 
	set implicit_transactions off
	if (@@trancount >  0 )
	begin
		raiserror( 15002 ,- 1 ,- 1 ,'sp_addrolemember')
		return ( 1 )
	end

     -- ROLE NAME (OBTAIN OWNER FOR PERMISSIONS) --
 
    select @roluid = uid, @owner = altuid from sysusers
                where name = @rolename and issqlrole =  1 

     -- ERROR IF ROLE NOT FOUND OR PUBLIC --
 
    if @roluid is null or @rolename = 'public'
    begin
	    raiserror( 15014 ,- 1 ,- 1 ,@rolename)
	    return ( 1 )
    end

     -- CHECK PERMISSIONS --
 
	 -- Only member of db_owner can add members to db-fixed roles --
 
    if (not is_member('db_owner') =  1 ) and
       (not (@roluid <  16400  and is_member('db_owner') =  1 )) and
       (not (@roluid >=  16400  and is_member('db_securityadmin') =  1 )) and
       (not (@roluid >=  16400  and is_member(user_name(@owner)) =  1 ))
    begin
		raiserror( 15000 ,- 1 ,- 1 )
		return ( 1 )
	end