We use Log Explorer and it has a pretty small footprint on the server.  It installs a read-only extended stored procedure in the master database that can be secured for...

I prefer to use sp_reassign_dtspackageowner in msdb.  It's parameters are the package name, package Id, and new package owner logon id.

Greg

Check "Insert batch size" on the Options tab of the Data Transformation task properties.  I think the delay you see while watching package progress is caused by the rows inserted being...

That will update the full-text index if the data in the referenced columns changes, but not if you add or remove a performance index.

Greg

You can't enforce this with foreign key constraints because you would essentially be making each table both a parent and a child.  You wouldn't be able to insert or delete...

There's no built-in way to do this in SQL Server.  You'll have to build it yourself using DTS, replication, log-shipping, or T-SQL depending on your requirements (location of the archive...

No, full-text indexes and catalogs must be explicitly rebuilt.  There is no connection between performance indexes and full-text indexes.

Greg 

Michael,

My suggestion is to import the data into a staging table in SQL Server then use T-SQL to update what you want in the destination table.  I assume both tables...

I'm researching the possibility of updating Active Directory from SQL Server.  Has anyone been able to successfully use an Openquery UPDATE to push data to AD?

Thanks,

Greg

Also, transaction logs are not text files and can't be imported by DTS.

Greg

Your update statement will work fine.  You could also use

UPDATE dbo.mytable

SET col3 = '9'

WHERE col3 = '8'

Greg

Darren Green has some suggestions for executing DTS packages from applications.  See http://www.sqldts.com/default.aspx?104.

I've used a solution for this that involves the having a request table that has a row inserted by...

Yes.  Backup the log right now.  Now, you can restore the database from the last full backup and the log backup to a point in time. 

You'll still be stuck...

You can also have your t-log backups write to separate files so the file being written to isn't the one that's being copied to tape.

Greg

You're right.  Your network guy should be able to tell you how long the disk to tape backup takes so you can schedule your log backup interruption for the minimum...