"Nope, thats not very useful."...but it was a starter attempt for free.....it's taken you 3 days to get to this point and you're being paid (???)....you seem to have forgotten that none...

Regardless of how this intereacts with .NET, your 1st priority is to ensure that it executes efficiently in T-SQL.  Have a look at (or post) the execution plan for the...

Best approach is to execute the steps 1 by 1 and inspect the database and try to deduce the changes each section implements.

For a start the 1st 2 bits, create...

I'm being obvious here ()....but the "EXEC sp_addlinkedsrvlogin txtsrv1, FALSE,null,'admin', NULL" statement has 1 extra 'null' after the false.

If you read the...

Those are administrative details.....and not sexy for a cio...or ceo.

Concentrate more on risk (downtime, bad apps, bad data, lost business, disconnected business processes, SOX) and the cost of failure thereof. ...

you don't need public resources....you could download MSDE (cut-down version of SQL Server) and create databases privately.

"Be sure to have a mechanism in place to trap for that possibility."

a DOS rename of FILEA to FILEA, testing for a 0 retcode will prove that a file is not...

This issue has been raised on http://www.SQLTeam.com and relates to a bug in SP4, which has been acknowledged by Paul Randal of the Microsoft SQL Development team.  Search there...

Why not just use the SQL Scheduler (or any other suitable package) to schedule 1 pass of the DTS package every minute?

Don't complicate things....use what tools are there already.

The following is from today's Question of the Day (QOD).  It highlights how to recover to a point in time, using backup datasets and transaction logs....IT should be mandatory reading...

Sorry to report that the "The case-study hotlinks don't work (for me)" as implemented.  They come up as prefixed by the article address.

Otherwise...very interesting...

"Have you never had a bank account changed to a new account number? What do you do when senior management decides that fund abc-12345 is now going to be named...

"........is to go back to the last database backup and then applying (aka rolling forward) the database transactions upto the thime the begin transaction command was issued."

Investigate the RESTORE command,...

"One problem we discovered is that Table A had the rec_id field as integer, while table B had it as varchar"...DATA conversion issues will ALWAYS cause performance (and data quality)...

IMO - the whole point of an image, is as a locked-copy of a document at a point in time, any modifications, should be stored seperately as overlays.

I don't work with images...