[dbo].[tng_add_sysobjid]
(local)
>
mdb
>
Stored Procedures
> dbo.tng_add_sysobjid
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@classname
varchar(30)
30
@sysobjid
varchar(251)
251
Permissions
Type
Action
Owning Principal
Grant
Execute
uniadmin
Grant
Execute
wvadmin
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
[dbo].[tng_sysobjid]
dbo