Home All Groups Group Topic Archive Search About
Author
10 Jan 2007 7:22 PM
BMW
Hi,

I have sink event which is get data from incoming mail on exchange server
and insert the data to SQL server. Both Server are under same doamin. The
data can be added if the exchange has Visual Studio. Without the visual
studio on Exchange server, the sink fire but no data is added to the table.

I don't understand the store procedure return @@rowcount is 1, but the data
is not in the table.; I refreshed the table, and the data was not there.Also
I used the tool of the server profilo to track the process. I saw the user
could log in and run the stroe procedure.

I already set the DTC timeout for 5 minutes.

Do you have idea what's wrong ?
Thanks.

AddThis Social Bookmark Button