Well well well. It has been found continous synchronization of more than one publication when old one is generating the snapshot will lead in to deadlock and would fail bulk...

Hello everyone,

if we skip the snapshot agent dialog then there will not snapshot generated.

Ta

An Update...

As said above since there is an error delivering the snapshot , I have found that StoredProcdure/Job sp_msacquiresnapshotdeliverysession_lock seems to hold lock on publisher table which is...

You are correct. As we are still in development phase , I havent considered it. Did scheduled the job now that runs every night.

Thank you very much.

Ta

An update...

Reindexing has helped much and there is better performance.

Thanks

Well said... Im using transactional replication.

Ta

When I queried DBCC ShowContig , scan density was only 13.5%. Now I have reindexed the table wi the scan density being 99.67% as a result , hopefully should see...

Distributor is cofigured remotely. I have seen few locks on to my destination table and even after stopping job or disabliing the publisher PAGELOCK seems to exsits. As suggested above...

I have just diasbled the log reader. There has been page lock on to my subscriber table... need to investiagate further.

Sorry for not making it clear at first attempt. Im aware that disticnt applies to all the columns. I have checked that ugly_ID and other columns are equal for...

I have double checked that temporary table doesnt have any duplicated data by running this query

select user_id, count(ugly_id) from #tempworkingaddress

group by user_id

having count(ugly_id) > 1

and everytime when address...

Well , I guess if I limit the insert\delete trgiger to my replicated live copy and just use update trigger from my new model I, dont have to worry about...

I found this post useful and thought would try this solution

http://www.red-gate.com/Products/SQL_Comparison_SDK/case_studies/synchronizing_databases.htm

Ta

Hi folks,

It worked.. I just populated bulk number of rows on my publisher and checked my destination table and it worked properly.

Ta...

I have tried inserting one new record on publisher that fired my custom trigger.. Will have to investigate why for bulk update trigger is not being fired.

Ta