Re: Database Replication



Ryan,
I agree with Adam, but just to clarify, if you mean queries applied to the
publisher then there' s no issue, but if the query is to the subscriber, you
might experience the normal blocking issues. The new snapshot isolation
level can be of use here. I have no stats regarding the performance
comparison between database mirroring and replication as yet.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .




.



Relevant Pages

  • RE: filtering table data on a form with combo boxes
    ... "Adam" wrote: ... I'll leave it at this so far, to see if i am helping, and to ensure you can ... below the combo boxes. ... the query I get an error message "compile error. ...
    (microsoft.public.access.gettingstarted)
  • RE: ADAM AND ASP.NET
    ... > I configured 3 machines on the same domain ... > Windows 2000 Server ... > ADAM ... > From machine A I can successfully execute the following query to return ...
    (microsoft.public.windows.server.active_directory)
  • Re: MAKING A QUERY TO RANDOMLY MAKE A 100 QUESTION TEST
    ... Adam, you won't get a better answer than Tom's. ... If you need an example of what to type in the Field row in query design ... Don't forget to execute a Randomize in the session before you run this ... > Thanks for the response Tom, i will try this on monday. ...
    (microsoft.public.access.queries)
  • Re: ADAM as a Linked Server
    ... Check that the service account the other SQL server is using has sufficient ... impersonating the caller when connecting to ADAM. ... From a SQLServer_A I can query the ... > OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ...
    (microsoft.public.windows.server.active_directory)
  • Re: printing double sided in Publisher
    ... If you are using 2003 and before, View, uncheck two page spread, go to page one ... click no to the query and so on.... ... Mary Sauer MSFT MVP ... Why can't Publisher do that? ...
    (microsoft.public.publisher)