Are all the sp owners in the db going to be the same?

Or do you have a list of those to be changed in a table?

If you just want a picture why not just get the diagram onscreen and hit the PrtScn button, paste that into an image program?

pray do tell....notify failed jobs trigger?

I have a job step right now, but it's a pain in the preverbials to add the step for each job, where is the trigger...

It could also be an issue related to attempting to save the query accross the network especially if you have the Nortel client installed on the machines involved.

I think you already hit the solution on the head....

You need "one ring to control them". Putting someone in a broad overview position to assess projects and assignments, apportion out...

It will make the call directly to the procedure with the ;#. So if it wanted to exec sp_msins_orderstatus;2 it would call that part. Apparently it's a versioning tool and...

I could be mistaken, but aren't these incarnations of the proc as regards changes to replication / service pack upgrades?

First thing, try recreating the indexes on that table (drop and create, or create with drop existing) and see if that resolves the problem.

How about removing FTS as a clustered resource once the install is complete?

Great question, got it wrong, but great question.

Following up on what Douglas said regarding backups, one thing that you might be tempted to do is to use the SQL Client for arcserve to allow you to backup...

Things always look different on a Monday...I would not think about it at the weekend and then come back to it on Monday.

A parting thought is that if it's...

People have said great things about the logship scripts posted on this site. I've never used them, I have used the SQL Logshipping and not had any serious problems.

We don't do much in the way of schema changes through the Remedy tool, and when we do (because we replicate a lot of the data) I am around when...

What's the script that you are trying to run to update the column?