Re: Diabling Snapshot Log per session

Snapshot logs are updated via a trigger. If you have permisions to disable the trigger, that would do the trick. However, if the goal is for the snapshots to refresh fast, they will fail to do so as the snapshot logs will be out of sync with the table. To fix that problem you *may* have to do a full snapshot refresh which will of course, bring over the changes.

In short, I began this post thinking yes, that should be possible, and I have now talked myself out of that idea :-)

--
Dave A


"Bruce Sargent" <email_me_at_nospam> wrote in message
news:39cd9769$1_at_news.microsoft.com...


> Is there a way to disable snapshot logging for a given session? I want to

> write a program that will apply changes to the base table without the

> changes being replicated.

>

>