That would make a most excellent article Brian....

On failure will execute in the event of a failure, do you have the ON FAILURE workflow going towards the package?

Be careful not to have multiple on failure workflows...

It's last in the list, however that's not the execution order.

It adds components to the list in the order which they were added to the package.

Presuming that this is the 32bit Windows on 2003....

If this is a hot-memory added device you don't have to enable PAE, if not however I would leave the /PAE switch...

However if you prevent access to MSDB the user will not be able to see the jobs, or start them.

Dan,

you have to start SQL in single user mode to restore the master db. Check that it is in fact master that you want to restore. You can check out...

Users in a database is pretty simple...

Select p.SPID, P.STATUS, P.BLOCKED, P.CMD, P.CPU, P.PHYSICAL_IO, P.LAST_BATCH, P.PROGRAM_NAME, P.OPEN_TRAN, P.HOSTNAME, P.LOGINAME

from master.dbo.sysprocesses p (nolock)

join master..sysdatabases d (nolock) on p.dbid = d.dbid

Where d.[name] =...

Would preventing access to MSDB not accompish this?

As KAthi said, I would use the DBID instead.

If you have restored the master database from another server you will need to make sure that it knows that it's on a different machine, run

sp_dropserver <old_name>

go

sp_addserver <new_name>, 'local'

go

unless...

If you change the server IP address and you are connecting using the server name also make sure that the DNS entries are updated accordingly.

Are you attempting to connect to a named instance? It could be a case of not including the instance name when attempting the connection through the IP, this is especially...

Looks like it has most of the information that I'm after, thanks Brian. Special notice needs to be taken with regards to the link 307532 How to troubleshoot...

Not the SQL service accounts themselves, rather the service account that the cluster uses.

Within a job use the DTSRUN utitlity. You can use this to execute each package and set an on success/failure for each.

You can look up the syntax in BOL, however...