SET QUOTED_IDENTIFIER OFF
GO


   create procedure GetNewSeqVal_HARSTATESEQ as
   begin
   declare @NewSeqValue int
   set NOCOUNT ON
   begin tran
   save tran seq
   insert into HARSTATESEQ default
   values
   set @NewSeqValue = scope_identity()
   rollback tran seq commit
   return @NewSeqValue end  

GO