[dbo].[bckdef_server_version]
(local)
>
mdb
>
Stored Procedures
> dbo.bckdef_server_version
Properties
Parameters
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@domain_id
int
4
@bck_id
int
4
Permissions
Type
Action
Owning Principal
Grant
Execute
ca_itrm_group
SQL Script
/****** Object: Stored Procedure dbo.bckdef_server_version Script Date: 12/1/2005 11:49:14 PM ******/
/*
************************************
*
*/
CREATE
procedure
bckdef_server_version
(
@domain_id
int
,
@bck_id
int
)
as
begin
update
bckdef
set
auto_server_version
=
auto_server_version
+
1
where
domainid
=
@domain_id
and
bckid
=
@bck_id
end
GO
GRANT
EXECUTE
ON
[dbo]
.
[bckdef_server_version]
TO
[ca_itrm_group]
GO
Uses
[dbo].[bckdef]
dbo