I'm sorry to say that there is no way to view or reset the owner password.  Perhaps the developer saved a previous version of the package without a password?  If...

What recovery model is used for the destination database(s)?

What are the details of your import? Are you only moving stored procedures? Are you dropping and recreating the objects in the...

Restore the database backup to a new database then use DTS to replace the tables in the original database.  See "How to restore a database with a new name" in...

There is role in MSDB called TargetServersRole that allows members to view jobs.  It's undocumented and subject to change in future releases and service packs, it works now.

Greg

Make a backup of the existing database and restore it with a new name.  See "How to restore a database with a new name" in Books OnLine.

Greg

You have to restore a full database backup before restoring a differential.

Restore a full database backup using WITH NORECOVERY i.e.

RESTORE DATABASE mydb FROM mydbbackup_bak WITH NORECOVERY

Then restore the differntial...

A user database backup contains all objects in the database including the objects you listed.  A backup of the msdb database contains jobs and DTS packages because data about them is...

You do need Enterprise edition to do Microsoft log shipping.  Here's a link to an article for a home grown log shipping solution that can be implemented on Standard edition.

You'll either have to disable the foreign key constraints on the destination tables before loading the data or you'll have to load the data in a specific order i.e. parent...

There's another thread about this in the Backups forum: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=142470#bm142884

Greg

I haven't used DTS to import from AS400, but you should be able to specify the login and password in the AS400 connection in your DTS package.

If you can provide...

It may be a permissions problem.  Scheduled packages run under the security context of the login that starts SQL Server Agent. Check the permissions of that login.  It has to...

I'm making some assumptions about your situation, so please correct me if I'm wrong.

I assume you're using the DTS import/export wizard and that the primary key of your

table is...

Ahhh, here's the link:

http://www.datamodel.org/DataModelLibrary.html

Greg

Here's a quote from Books OnLine:

The Unicode specification defines a single encoding scheme for most characters widely used in businesses around the world. All computers consistently translate the bit patterns...