Hello! Steve

the thing is , we write our queries and business logic in the DLL.actually the query is inside a loop that performs using wild card character search with LIKE...

hello! Steve

thank you for the suggestion regarding replication.

will try to follow accordingly.

Hello! Andy

Thanks for your suggestion, but one doubt i have is ..Would the transactional replication affect the main Production server while performing replication at very regular intervals, as there would...

Hello! Steve

Thank you for the useful information provided.

Deepu

I think usage of transaction statements would fix the problem ,if the DML operations are performed in the loop and if the data is saved partially.Or please can you tell...