He's back..... But looks like he doesn't like our "requirements" for getting help and

I'll be looking for a forum a bit more consistent with my prior experience so as...

bitbucket (12/16/2008)

---

Jeff

Jeff should I be proud of this nomination and...

Took your advice and deleted the entire post.

Jeff Moden (12/16/2008)

---

Heh... gotta think "pork...

Instead of trying to describe in words what the result set should be, show us what the result set should be. You don't need to know how to write...

Was that good enough over there? I hate it when I click on a link in an email notification and it dies.

Jeff Moden (12/16/2008)

---

Lynn Pettis (12/16/2008)

---

Well, looks like Jeff's twit logged on today, but I haven't heard squat regarding the code I provided. I guess the first pork chop Jeff...

Okay, so based on those simple examples, what have you come up with and what problems have you encountered?

Amol.Naik (12/16/2008)

---

The Transaction log backup is assumed to be running every 10 or 15 minutes in a Production environment. BACKUP LOG command could be used in scenarios where the transaction...

Maybe. That's the first thing I'd try, but then I'm the type to jump in and try things.

Amol.Naik (12/16/2008)

---

Firstly the deletes on Production has to be happen off-hours, this will avoid any blocking.

Secondly the deletes have to be in batches, say in a batch of 3000 to...

Just to be sure, your last posted code was your corrected code and is working correctly, right??

Is everyone who attempts to run activity manager getting this error? If so, you may have a corrupt dll (mscorlib) on the system and you may need to replace...

Here is a consultants answer; It Depends.

You'd have to look at the queries you have written in your stored procedures to determine if one table or two is the best.

Well, now that you have updated the code, what is wrong? Also, for better answers to your questions, please read and follow the guidlines provided in the article I...