That's the answer I was looking for. I don't know why I didn't find it, but thanks for that.

And therein lies the trouble. I realize it says IS with basic transforms are not supported in Workgroup, but I don't know what that means as far as what I'm...

I have, and while derived columns isn't specifically listed, I didn't know if they were included in some other category.

Hm, I didn't see that before.

That did work. This time I dropped the publication using sp_droppublication whereas before I dropped it by right-clicking the publication in SSMS and deleting...

I have deleted everything from that table with the offending publication_id, and I've done the same to all the other tables in distribution that look likely. I really don't...

I did, the response I get is "The publication 'Prod_1_TL' does not exist."

Oh, nice. That looks a lot easier than what I was trying to futz with. I have a script that will rename any table fitting certain criteria, and...

I'm having this same problem. However, I have never renamed this server, it's just never worked.

I created all-new virtual directories using the default settings, and still nothing. I...

Probably so. It's a week's worth of data but the tables on which I was using GETDATE() as a default are few and far between, and I don't think...

Ah, I see what you're getting at. I've been racking my brain trying to figure out a way to fix all the dates in there from the past week...

Thanks for the response.

I have tried that one, but it doesn't round the date - it just drops the millisecond value.

I have, but I hadn't thought about applying it to this situation. I'm already pulling a backup file down every night anyway, and if I don't have to worry...

Ellis, thanks for the response.

I had read that article in BOL before, but none of that is a real help to me. I'm not wanting to restore a backup...

I have the Z: drive mapped to the remote server. Also, the FOR statement works on Server 2003, but it would need to be changed if you're using Windows...

I do something similar, although it might be overkill for what you're trying to do. I have a batch job set up to zip up and encrypt all .bak...