1
  • Email Trigger failing in SQL Server 2012

    I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...

    ITKE434,335 pointsBadges:
  • Trigger

    What is the use of the trigger?

    swamy00725 pointsBadges:
  • SQL trigger on column

    Table have delete and update trigger. How to identify which columns are affected by this triigers? or  which column have  triggers ?

    Lkjh123415 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • ORACLE-TRIGGERS

    Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time)...

    RizwanSharief30 pointsBadges:
  • SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

    I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that...

    ITKE434,335 pointsBadges:
  • Working TRIGGER and TRANSACTIONS QUESTION

    Hello all, My company purchased an operations software (called [strong]darwin[/strong]) that works with SQL 2005 Server. I need to extract some data and save it in my Own Database, which is located in the same SQL Server. On the darwin software there is a screen that updates a field X in a table,...

    LUISCGG5 pointsBadges:
  • Why does my SQL Trigger malfunction?

    I have the following code installed on my database. Create Trigger CFXSOUpdate On SalesOrder For Update AS If Update(SOM_DefaultRequiredDate) or Update(SOM_DefaultShipMethod) Declare @Body varchar (100) Set @Body= 'The Required Date or Ship Method has been changed' Exec master..xp_sendmail...

    Arlin70 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following