Stored Procedures [dbo].[tng_add_method]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@namevarchar(30)30
@typeint4
@exe_namevarchar(255)255
@parametervarchar(255)255
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecutewvadmin
SQL Script
/****** 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
Uses