Stored Procedures [dbo].[bckdef_server_version]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@domain_idint4
@bck_idint4
Permissions
TypeActionOwning Principal
GrantExecuteca_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