Teaching my eight year old to play golf. Playing a bit of golf myself. Enjoying the nineteenth hole, no matter where it is.

Gym, squash and rugby (just a spectator these...

What a shame I don't drink coffee or tea.

As you cna see from the by-line, I'm not afraid of a beer or 12. Hence I am also overweight and...

Very confusing.

Are you absolutely positive that your applicatino triggers are NOT creating new rows?

SQL Merge replication keeps only references to the records and columns that have changed, based on the...

I haven't put too much time into this but it should be a starting point for you.

You will need to write a user defined function to calculate the elapsed time...

Perhaps it has something to do with NULLs being indeterminate. You state that

A NULL is a NULL is a could be anything (but it is not a 0)

But, if NULL...

The short answer from my perspective is to ALWAYS treat nulls as an exceptional case.

If you are relying on the presence or non-presence of a NULL value, then specifically test...

If you're planning on using Standard edition, aren't you limited to Standby server? I thought clustering was only available in the Enterprise Edition?

I think in the end it comes down...

A starting point would be to use sp_helpindex.

This tells you some information about the indexes for a given table.

If you wish to expand on what this gives you, you can...

From my experiences so far, I have seen that the trigger can fail in the subscription database. This failure may be related to an actio nthat th trigger is taking...

976.25 (Cedric) - gets me on the board - only took 1/2 an hour

From my quick look at the sql you posted, it looks like you are using the cursor to select a couple of values then doing an insert and an update...

Not sure if I have the rioght end of the stick here, but I presume you are looking ofr a query that allows you to update based on a join?

something...

You might find that you will need to run the snapshot agent as well so that the new permissions are picked up.

I'm not sure of you're topology, but so long as you have SP4 at all subscribers as well as the publisher then the data shouldn't be going missing.

The other thing...

Re-runnning the snapshot

In the Enterprise Manager under the replication monitor, you can drill down to see the Snapshot Agent for your publication. When you right click on that you have...