|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server profiloHi,
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. |
|||||||||||||||||||||||