In Object Explorer, expand Management, expand Legacy, expand Data Transformation Services.  The packages listed are those that are stored in msdb.

Greg

SA,

Did all the jobs stop working or only some of them?  If only some, what do they have in common? 

My experience with jobs that show they're executing but never...

The same way you'd restore a user database except you'll need to stop the SQLSERVERAGENT service to ensure that there are no connections to msdb.  See "restoring msdb database" in...

The table is owned by dbo, but is the stored procedure also owned by dbo?  The objects in both databases must have the same owner.

Greg

You could try using the results of SP_HELPSRVROLEMEMBER which returns the same thing in both SQL 2000 and SQL 2005.

Greg

Another suggestion for moving DTS packages:

DTSBackup 2000 is a free tool at http://www.sqldts.com/242.aspx.  It will copy multiple packages so you don't have to open each one and save them...

Did you enable cross-database ownership chaining on both databases?  Are stored procedure and the tables owned by the same login?

Greg

According to BOL:

Only a job owner or members of sysadmin can edit jobs.

Only a job owner or members of sysadmin can change a schedule, though a member of SQLAgentOperatorRole (with sp_update_schedule) can...

I'm assuming there's some processing that goes on during the four hours that needs to happen before the data can be copied to production.  If that's not true, I think...

Okay, sorry.  Let's try something else.  Open the previous version of the package that still has the connection object referencing the deleted database.

Open the properties of the connection object and...

Right-click on a package in Management Studio and select "open".

Greg

I think you can detach the current MSDB database, move the database files of the old database and reattach.

See this article: http://support.microsoft.com/kb/224071/

Greg

Don't delete the transaction log unless you want to spend some time with an inaccessable database.  The transaction log is not a static file that can be deleted at will. ...

Now that you know the row length, multipy it by the number of rows returned in the query. 

Greg

Actually, in SQL 2000, schema is equivalent to the owner of an object.  So, if all the objects are with 'dbo' e.g.  'dbo.tablename' or 'dbo.sprocname', 'dbo' is the schema name.

Greg