Stored Procedures [dbo].[nctpldef_server_version]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@domain_idint4
@tp_idint4
Permissions
TypeActionOwning Principal
GrantExecuteca_itrm_group
SQL Script
/****** Object:  Stored Procedure dbo.nctpldef_server_version    Script Date: 12/1/2005 11:49:38 PM ******/


/*
************************************
*
*/



CREATE procedure nctpldef_server_version(@domain_id int, @tp_id int)
as
begin
      update nctpldef set auto_server_version=auto_server_version+1
      where domainid=@domain_id
        and tpid=@tp_id
end
GO
GRANT EXECUTE ON  [dbo].[nctpldef_server_version] TO [ca_itrm_group]
GO
Uses