I just want to say Thanks for this article. When setting up server side trace scripts last week (for the first time) I was annoyed at how cumbersome and...

Transactional Replication. Thanks for the link, it looks very useful.

The link talks about changes to the object DDL on the publisher and seeing that go through to the subscription...

I see it was a silly question now. All but the last restores should be RESTORE WITH NO RECOVERY and the last restore can be the one with RESTORE...

It sounds like this could be it. Since it's a production system I'll have to wait to apply SP2 but I'll post my results when I have done so....