It sounds to me like you have data redundacny in your database design. If possible it might be better to look at further normalising your design to eliminate the problem,...

If this is a dumb question, disregard it.

Have you tried right clicking the Snapshot Agent and running it explicitly?

I have found that even though you select "Run Snapshot Agent Immediately"...

If this is a dumb question, disregard it.

Have you tried right clicking the Snapshot Agent and running it explicitly?

I have found that even though you select "Ruin Snapshot Agent Immediately"...

I've just come off a replicatoin project where we were losing foreign keys in the DB. Also could not track the DROP statements. We did not look at the log,...

Hi there,

I've just come off a project that experienced a sudden degradation in performance. It was like turning off a tap. We found that restarting the server did solve the...

Yup, you're right. I don't know where my head was when I did the post. I've actually used dateadd() and datediff() and not had to do anything about leap year...

Thanks. In hindsight it is rather obvious I guess.

morphuez

quote:

---

Try this......

select isdate('29 Feb 2003') = 0 (False)

select isdate('29 Feb 2004') = 1 (True)

...