Stored Procedures [dbo].[tng_add_sysobjid]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@classnamevarchar(30)30
@sysobjidvarchar(251)251
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecutewvadmin
SQL Script
/****** Object:  Stored Procedure dbo.tng_add_sysobjid    Script Date: 12/1/2005 11:49:42 PM ******/


CREATE procedure tng_add_sysobjid (@classname varchar(30),
@sysobjid varchar(251) )
as  declare @class_id int

/*07/09/96 disable checking
select @class_id = null
select @class_id = class_id from tng_class where name = @classname
if @class_id is null begin
raiserror 90025 'MSG:(90025) add_sysobjid: bad @classname'
return
end
*/


insert into tng_sysobjid ( class_name, sysobjid  )
      values(@classname, @sysobjid )

      return
GO
GRANT EXECUTE ON  [dbo].[tng_add_sysobjid] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[tng_add_sysobjid] TO [wvadmin]
GO
Uses