BEGIN TRY
          TRUNCATE TABLE tblXYZ
      END TRY

      BEGIN CATCH
        SELECT
          ERROR_NUMBER()    as      ErrorNumber,
          ERROR_MESSAGE()   as      ErrorMessage
      END CATCH