Service Desk Practitioners Forum
cancel

SQL Server 2000 Trigger & Service Desk 4.5

Highlighted
Vladimir V.B.
Trusted Contributor.

SQL Server 2000 Trigger & Service Desk 4.5

Hi
I am use SQL Server trigger for calculate date time value,but I get form "Merge result"(look attach) from SD and trigger's change not commited in SD. How i can resolve this problem
Best Regards
1 REPLY
Vasily Kamenev
Acclaimed Contributor.

Re: SQL Server 2000 Trigger & Service Desk 4.5

Hi
you see the Merge when data in DB is changed but in form not.
You need create Rule for calculation, use script the best way or use Rule where you will use one boolean custom field and your trigger must be run after this field is changed.

Vasily