we captured the cause of deadlock and hence introduced tablock. any other option kindly revert.

Yes there is interdependency between the procedures and yes error handling and roll back is done. In each procedure explicit transaction is done with its error handling. Table 1 is...

Hello Dennis. Thanx for reply. Yes MS SQL will be used. But Wouldn’t trigger be resource expensive. Our system is going to be live 24x7. The data are time incremental...

Hello,

Thank you all for your efforts in replying. I could trace back the issue. The flow of the stp was not proper and hence the issue.

Regards,

Saumik Vora

Hello,

Of course the COMMIT TRAN have been put within IF and the same has been deployed already.

The question here is why in first couple of days this error did not...

Hi,

thanks for replying back. due to policies i will not be able to provide actual code but i can replicate with dummy tables. Following is the details for your ref

tblA ...

Hello,

@Jeffery and @dennis, The reason i am creating temp table with all the columns is because it will be used multiple times in the stp and all the...

Hi,

Thanks for reply. I had thought of the same of pulling the data from source. the flow will be as

Source stp calls Destination stp. This destination stp connect and pull...

Hi Erland,

We have used the profiler and included SP:StmtStarting and SP:StmtCompleted events but today will check with the error ones. However i am still looking out ways to debug the...

Hi Erland,

Thanx for the help. i figured out the issue. there was space between Param variable and the value in Param definition.

Noted about the type of the question as well as insert/edit code.

Now i passed the parameter without quotes, but still blank value is getting passed to the stp instead of...

Hi Erland,

I followed the step as you guided. however the output did not come. On checking the profiler i found that parameter value is not getting passed. The value of...

Hi,

Just some time back i came to know that in a single machine they are using two network cards. The setup runs properly in one card, but gives error when...

My previous answer was for Thom A. 
@mark-3 Tillman yes i did change the query, but we would like to know the cause why its getting slow. also...