Tagged Questions

1
vote
1answer
125 views

SQL 2005 Replication - How do I get the DA Profile MaxBCP option to work with a Transactional Publication?

I have two publications on a database. One is a transactional publication, the other is a snapshot publication. We have a stand-alone Distributor (separate from the publisher) and both publications ...
3
votes
1answer
723 views

Remote queries at SNAPSHOT isolation level

I'm experimenting with snapshot isolation level. Whenever I try to access a linked server, I get an error: Remote access is not supported for transaction isolation level "SNAPSHOT" I wasn't able ...