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: ADAM Security Logging
    ... the User column of the ADAM instance event log for a native ADAM ... To get a security log audit when a native ADAM user connects to ... > return a limited number of entries per query. ... This works great when an AD account ran the query, ...
    (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)