If you can't use a log reader tool, then follow Chris's advice and restore the database with a new name. Then you can select the rows you want and...

I think you'll need to use the DTS Object Model. Check out this article: http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/

You can't restore backups of SQL 2000 system databases i.e. master, model, or msdb in SQL 2005 because of all the structural changes in SQL 2005.

Good advice from Chris. You couldn't roll back the transaction because it had already been commited in the package. You can only roll back a transaction that you...

I agree with Adam. I also suspect that, because a lot of people were used to storing DTS packages in msdb in SQL 2000, MS kept that option.

It's wrong if you can't trust them to manage the database responsibly. Who is responsible for backups - you or the clients? If it's you, then you shouldn't...

Query the sysarticles table in the publishing database.

Hi Bob,

Are you dealing with legacy DTS packages or SSIS packages? The "dts_" database roles in msdb work only for SSIS packages stored in msdb, not for DTS packages....

If by "administrators" you mean members of the sysadmin server role, you can't prevent them from accessing any database. They don't even have to be mapped to a user...

jsheldon,

What errors do you get when you execute the package? There's no guarantee that it'll run in a job either if we don't know why it won't run manually.

Whoever is making the backups must be a member of the sysadmin server role, the db_owner database role, or the db_backupoperator database role. Remove anyone from those roles who...

Yes, you can either right-click on Users in the database and select "New User..." or you can do it at the login level like I described in my previous post....

It's SET DEFAULT. See "Alter Table" in BOL.

Yes. Create the logins then assign database access to the login, which will create a user in the database.

In SSMS, expand Security, right-click on Logins, and select...

...and if you're asking how to "renumber" the identity column so there are no gaps, I'd say you're wasting your time. The values in identity columns shouldn't be perceived...