Adam,

There is a published work of Adrew Zanevsky on detecting the most heavily used queries in which profiler traces are scrubbed to determine the usage and impact but they stop...

Khalid,

Let me clarify my statement.

I didn't say  Bigger table = Most Utilized

I said Bigger Tables are usually the most utilized.

This is the reasoning behind it:

1. To...

I have discuss this issue too many times with friends and coworkers but it seems like an endless loop

The method for checking existence...

affinity mask is a very specialized setting and should only be used in extreme situations and very tunned systems. IMO: Leave this alone

A not too crazy assumption is:

Your bigger tables are usually your most utilized tables

I don't know what happened but I believe I deleted somehow my previous post.

Anyways the Deal is that I depends on how is the setup done. If Remote Agent activation...

If your sever is configure to use the SQL Agent proxy account and you are running this code from a job and that job owner is not the current login...

when you restore a backup of a database in a server that has nothing replicating all replication metadata is supposed to be removed. I know this may not be what...

script the triggers out an use it in the post snapshot script!

hth

Sure,

Is what I usually do on a laptop or a dev machine to troubleshoot or debug or try a proof of concept  locally

hth 

There is another thing to consider when you use multiple (independent) agents. You can select not to run them all continuosly and schedule them as appropriate for each of the publications...

Graeme100,

That's a "trait" of the SQL Agent. It updates the next run time AFTER it finishes. When you schedule a job to run...

I believe you can.

But steps are very strict.

1. Let the Snapshot create the table.

2. Modify the Table structure at subscriber using a post script

3. Modify the procedures ins,del,upd  for the...

HLEBOEUF ,

Just do not check the immediate updating nor the queued updating boxes on the Transactional/Snapshot Publication Wizard

hth

To Sue Meunier 

Form BOL: