22/7 and Pi are only equal to the second decimal place

22/7 = 3.142857142857143

Pi = 3.141592653589793

Script out the table on the publisher and then recreate it on the subscriber. Once you have done that the reinitialization with the snapshot will synch the table back...

The problem is that removing the data from the database does not cause the size of the database to go down. Then when you back it up you are...

The portion of Wayne's code that you are referencing is only there...

No problem, glad to help. 🙂

The error is simply stating that the field that you applied the constraint to contains values that do not exist in the table that the constraint references.

Check out this function. It makes deleting dupes quite simple.

Correct your 2008 licenses should be downgradeable.

Your standard edition license does not cover you for dev edition however, a dev edition licenses are ony like $50.

Thanks for fixing the link Steve. I am not sure what I did wrong there. 🙂

It can be configured either way.

http://msdn.microsoft.com/en-us/library/ms175935.aspx

Kingston Dhasian (5/4/2010)

---

You can remove the JOIN in the above query this way..

WITH DupeRecords

AS

(

SELECT ROW_NUMBER OVER (PARTITION BY LOCATION_NUMBER ORDER BY ID) AS RowNum, *

FROM ForResiMailing

)

DELETE FROM DupeRecords WHERE RowNum...

Since I am not completely sure of your table structure given the information provided I am assuming that their is some sort of PK on the records. I am...

[/quote]

That is because: As per Pauls Blog:

The clearing of the inactive portion of the log is delayed until the full backup completes. This could cause you to have disk space...

Maninder S. (5/4/2010)

---

Also Pl do check that your jobs do not OVERLAP.. i.e schedule them at diff times.. e.g : if you do a full backup of all the databases...