A
Arun
Hi,
I planned to send a custom alert messages for some peoples whenever an
issue/risk created in Project server. So I created a trigger for every insert
in AllUserData table of WSS_Content_80 database. When each row is inserted
into the AllUserData table the trigger fired but i am not able to fetch the
latest inserted row, only previous row is comming.I excuted the query with
READUNCOMMITED option also. What will be the reason? If I excute the query
outside the trigger, it is fetching the correct row.
Thanks,
Arun
I planned to send a custom alert messages for some peoples whenever an
issue/risk created in Project server. So I created a trigger for every insert
in AllUserData table of WSS_Content_80 database. When each row is inserted
into the AllUserData table the trigger fired but i am not able to fetch the
latest inserted row, only previous row is comming.I excuted the query with
READUNCOMMITED option also. What will be the reason? If I excute the query
outside the trigger, it is fetching the correct row.
Thanks,
Arun