USP_STEWARDSHIPPLAN_MAKEACTIVE

            create procedure dbo.USP_STEWARDSHIPPLAN_MAKEACTIVE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as begin
                set nocount on;

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                update dbo.STEWARDSHIPPLAN set 
                    ISACTIVE=1,
                    CHANGEDBYID=@CHANGEAGENTID,
                    DATECHANGED=getdate()
                where
                    ID=@ID
                    and ISACTIVE=0;

            return 0;

            end