WITH ENCRYPTION

FOR TRIGGER

**CREATE TRIGGER mytable_trigger ON mytable

WITH ENCRYPTION

AFTER INSERT

**CREATE trigger [tr_private]

on all server
with ENCRYPTION for logon
 
as 

BEGIN 

FOR STORED PROC

**CREATE PROCEDURE [dbo].[s_PDXBalnXfr]  
      @SourceBranchCode VARCHAR(3), /* Branch of the customer a/c */  
      @SourceMainCode u_MainCodeLen,   /* MainCode of the customer */  
      @BranchCodeCr VARCHAR(3),     /* Branch of the ac to be credited */  
      @MainCodeCr u_MainCodeLen,      /* ac to be credited */  
      @CyCodeISO VARCHAR(3),  
      @Amount MONEY,           /* Amount always postive */  
      @TranCodeDr VARCHAR(3),  
      @TranCodeCr VARCHAR(3),  

WITH ENCRYPTION