Thank you.
i have just finished reading about transactional replication
where it says that if one of the transactions fail to go to the subscriber then none of the changes go at all.
However, snapshot replication which is what I have gone for is apparently good for updating early on in the...
Thanks Very Much
I have completed that and in the main replication between the Pub and and the sub exists. However, i just want to ensure that replication is actually working.
There are no objects in the subscriptions directory even though the publication properties shows the subscription...
I wish to set up replication between 2 databases both on the same sql server. I wish to do this so that if the live db fails there is a mirrored version immediately available. ( is Snapshot or Transactional replication best for this I have read up on both but not sure still)
However as the...
I wish to set up replication between 2 databases both on the same sql server. I wish to do this so that if the live db fails there is a mirrored version immediately available. ( is Snapshot or Transactional replication best for this I have read up on both but not sure still)
However as the...
Hi
(Select Permission Denied on owner "dbo" on SQL Server 2000)
Running SQL Server 2000. I copied a database to be test/dev db. Configured the users on the db to be the same as the live db however the following error occurs whenever a login attempt is made.
Error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.