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

CREATE procedure tng_IsDiffClsSameIpNameExist (
        @class_name            varchar(30),
        @dsc_name            varchar(255),
        @ipaddr_str            varchar(16)
         )

as set nocount on                       
declare @obj_count int
/*it may return multiple rows*/






    select @obj_count=count(*)
      from tng_managedobject        
      where class_name !=@class_name and
             name = @dsc_name         and
            address=@ipaddr_str
  select @obj_count
GO
GRANT EXECUTE ON  [dbo].[tng_IsDiffClsSameIpNameExist] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_IsDiffClsSameIpNameExist] TO [wvadmin]
GO