Hi Guys

I have a problem same here

snap part of my code

LEFT JOIN tblAPBill

on tblAPPAymentDetail.strOrderNumber = tblAPBill.strOrderNumber

OR SUBSTRING(tblAPCheckBook.strLink,...

As of now, All i have is a trigger example :

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER TRIGGER [dbo].[trg_SynctblICInventoryCategory]

ON [dbo].[tblICInventoryCategory]

--WITH ENCRYPTION

FOR INSERT, UPDATE

AS

BEGIN

INSERT INTO [SampleData].dbo.ac_CatalogNodes (

CategoryID

, CatalogNodeID

, CatalogNodeTypeID

, OrderBy)

SELECT

isnull(c.CategoryID, 0)

,isnull(p.ProductID, 0)

, 1

,...

Yes, I do receive your reply. So based on your reply i need to add a Try catch in every trigger that I have or is there another option around?.....

Hi there,

Yeah it's true this script is created for Oracle so I am looking a way in where i was able to do it also in SQL 2005 do you...

Hi Guys

Browsing the net i found this useful information with regards to the issue i posted

CREATE TABLE error_log (

timestamp DATETIME,

...

Thanks Jack, I will definitely check the link that you gave:-D

Well Appreciated

Shyrill