/****** Object:  Stored Procedure dbo.tng_add_method    Script Date: 12/1/2005 11:49:42 PM ******/

CREATE procedure tng_add_method (
         @name        varchar(30) ,

           @type        int=null,
           @exe_name    varchar(255)= NULL,
           @parameter        varchar(255)=NULL
         )
  as     set nocount on              


       if (@name is null)
      begin
        raiserror 90028 'MSG:(90028) add_method: bad @name'
        return
      end
    
     insert into tng_method ( name,  type, exe_name, parameter)
                     values (@name, @type,@exe_name, @parameter)
GO
GRANT EXECUTE ON  [dbo].[tng_add_method] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_add_method] TO [wvadmin]
GO