Do you only care about changes in the platform? You need to use a subquery to find the previous value. Here's a basic query. Not sure it's what you want,...

Why service accounts? You could just change things to sa

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

Be careful about gaps in the identity column,

In 18 months there are probably 100,000 new people that have received the newsletter and not seen this article. We republish highly rated and highly read articles over time so...

I saw a survey last year that listed SQL Server databases, and like an idiot I didn't save it. It might have been 5GB, but it was single digit GBs.

I...

I think this is one place where the lack of code reviews happening is hurting code. When multiple people have to work with code, standards and comments get enforced fairly...

Same media should mean it's not corrupted. I'm not sure if that's the log file, but I've seen SQL setup put a log file somewhere in the Windows folder. Usually...

Grant Fritchey (6/18/2010)

---

GilaMonster (6/18/2010)

---

Lynn Pettis (6/17/2010)

---

Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or...

I would follow Suresh' advice. Delete in small batches. A large delete is logged as one operation, and you need the space to record all those changes in the log...

Did you check for a sqlsp.log or something like that in the Windows folder? I think setup logs stuff in there. Or is this from there?

Are you using same media...

Will this help? http://www.sqlis.com/post/file-watcher-task.aspx

You can hear some of the audience. Some presenters are good about repeating questions, some aren't.

Overall I thought they were pretty good.

This is another one of those areas where you have to walk a fine line. I've done a restore, you've done a restore. However practicing it, building skills to perform...

What's the right results?

Sounds like log shipping got out of sync somewhere. My guess is you need to remove it from the secondary and reset it up between them.