Since you've given no indication what the sp_executesql is executing or what proc_DeleteEventReceiver does, I have no idea. Why don't you investigate further?

Please note: 2 year old thread

Should do. Plus allows for potentially better performance than the datediff you had.

When restoring you have to specify the exact file name of the backup in the RESTORE statement

If you dropped the publication, no.

In that case '2013-06-03 00:00:00' as what you originally had ('2013-06-03 12:00:00') is noon, not midnight.

Mid day or mid night? Which are you calling '12:00 AM'?

WHERE [WorkForce_JobPosting].[Job Posting Create Date_JP] < '2013-06-03 12:00:00.000'

Why go complex when there's a simple method?

btw, 12:00:00 is mid day. That is what you want?

If you don't care about degrading performance for your users, shrink at peak time.

Exactly that. Once.

Excellent!

<Shameless self-promotion> There's a chapter on page restores in SQL Server MVP Deep Dives 2 </Shameless self-promotion>

Got nothing to do with the fact that it's a datetime.

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

Brandie, you can be sooo evil. 🙂

If you've already deleted the publication, then there's no information remaining as to what was replicated, that's defined in the publication.

It might be in the default trace, not sure though.