Ah, Charles, glad you've got some stuff for me.

Steve, I thought that this was 29 days late (as I'm reading it)....

Any chance you could share what you changed? Might help someone else.

Code would be nice if you can show it.

jonathan.crawford (4/29/2015)

---

Steve, I am having zombie subscriptions. tried to unsubscribe to notifications from The Thread three days in a row now, with no luck. Not that I don't love you...

Thanks for the update.

I hate triggers.

Are these databases or instances? There's a big difference.

That is really strange. Thanks for testing.

Along with the suggestion from mxy above, can you restore/attach on a third 2005Sp4 box?

Also, if you take a backup or create a small...

I don't know if they can capture table row counts. I'm sure they have data size over time.

That's interesting. Haven't heard of PIT issues, but haven't tested. I do know the GC can lag, but worst case might not be an issue for you since it doesn't...

Not sure what you mean by local v others.

You need to be on the console, not on a different machine.

That is strange. I can't help but think that you have a version issue somewhere, or perhaps a weird network issue. You also say a 2008R2 server with 2005 installed....

Filestream will help. SHould allow you to manage the performance aspect of deletions better. Make sure you kill 8.3 naming in the folder.

This works on Standard, and the code...

+1 to what Sean said. That would be my guess.

My guess? There's a function call on the command with one of the string functions that's limited to 4000nvarchar/8000varchar. The command field in sysjobsteps is nvarchar(max), but I bet some...

+1 for what Grant said.

licenses are administrative. No checking here, so just install on a new machine, use the license, and decommission the old one so that you don't get caught in a...