CREATE PROCEDURE [dbo].[VTRIGGER]  
   @input_trigger_name nvarchar(max),
   /*
   *   SSMA warning messages:
   *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
   */

   @input_full_report float(53) = 0
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   BEGIN

      DECLARE
         /*
         *   SSMA warning messages:
         *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
         */

         @trigger_count float(53)
     
      SELECT @trigger_count = count(0)
      FROM sysobjects
      WHERE xtype='TR' AND NAME = @input_trigger_name

      IF @trigger_count = 1 AND @input_full_report = 1
         PRINT 'Verify trigger ' + ISNULL(@input_trigger_name, '') + ' succeeded.'
      ELSE
         BEGIN
            IF @trigger_count = 0
               PRINT 'ERROR:  Verify trigger ' + ISNULL(@input_trigger_name, '') + ' failed.  Trigger not found.'
         END

   END
GO