Thank you. I will try both and see which one I like setting up better since it will be a common thing on several of my servers.

I...

After speaking with Microsoft it turns out there was some bad data in my table that was causing the filter to fail. We changed the filter to take that...

Thanks Roy. However, the replication has been set up and running (not modified) for a couple of months now and just started failing. So if it was related...

Thank you for your suggestion. I have found though that changing my script task to do the file.exists on the dir() function of that location it works and shows...

They have looked at it and said all of the disks are healthy. So we are assuming that the hard shutdown due to the electrical issue in our data...

Thanks Gail. I restored the distribution database and my replication was out of sync so I ended up reinitializing just to get everything back up and going. I...

Thank you. I pretty much figured I wouldn't be able to see it like I am used to, but I wanted to ask in case there was a way.

Gail,

I just tried to make the database backup of the Distribution database, but I got the original error from my first message as soon and I try to start the...

Thanks Gail, I like that suggestion of restoring this database elsewhere so I can see what happens when I try to repair.

Thanks Roy, that helps a lot. However, it looks like I have to look at each publication separately. In the SQL 2000 Enterprise Manager I could see all...

Thanks Marianne, I will give that a try.

Thanks for giving it a shot. Hopefully someone else has made it work and can give steps for the rest of us.

Thanks again for taking the time to try...

Thanks Gail. Based on the blog you provided the link to and your posts I assumed so, but since you asked the question about the two object id's I...

So based on that, do you still think my best bet is to restore from the old backup after I script out my jobs?

Thanks Gail.

When I run 'select * from sysobjects where id in (540225842, 540357684)' it returns no records. The same is true if I 'select object_name(540357684)' and 'select object_name(540225842)'.

Is there...