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

CREATE procedure tng_add_alarmset (
         @name        varchar(30) ,
         @comment        varchar(255)=NULL
         )
as         


       if (@name is null)
      begin
        raiserror 90030 'MSG:(90030) add_alarmset: bad @name'
        return
      end
       
      begin transaction addalarmset
        insert into tng_alarmset ( name,  comment)
                          values (@name,  @comment)
      commit transaction addalarmset
/*2/9/96
      exec tng_add_alarmset_entry @alarmset_name=@name,
                                      @start_sequence_no=1
*/
GO
GRANT EXECUTE ON  [dbo].[tng_add_alarmset] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_add_alarmset] TO [wvadmin]
GO