Yep. I have setup the access security correct for the accounts. And Firewall is disable with the domain. No idea yet....

It did not work, I followed steps suggested but did ot worked. Please , help me on this issue.

Some time we sxpect one more than one millions records in CDC in few tables...

Second server is used for reportings, Apps etc..

I actaully thought of doing diff back up and restoring but again it will require server to offline for at least an hour or so.

we do not want to take server down as its been used by International users. So building on seperate server and restoring after back up by making it offline for...

Is there Any limit on rowversion...i mean is thee any possibility that Database reached its maximum rowversion?

How you determine what number to subtract ...

What Algorithim you are talking about...can you explain