Have you tried placing debug lines in to identify which steps are executing?

E.g. write an event to the event log, a log file or better still create a table and...

Steve,

The links to the MS site seem to be out of date. All the ones I have tried redirected to an MSDN homepage.

Try running profiler when the DTS package starts and see if you can capture any events which are occuring.

Open Enterprise Manager, open MS SQL Servers, right click on SQL Server Group -> New SQL Server Registration.

This should allow you to register the server with your username password.

Note: ...

Joe,

Thanks for the article and the technique. I like the idea and think it will work well in a number of situations.

I am unsure why 'Herb' is attacking...

Another way to do this is to schedule another job to schedule an sp_stop_job. This stops the job in a far less graceful way but at the time...

My understanding was that that would maintain the SQL fragmentation. This data is very heavily fragmented and I am hoping the inserts will sort that by having...

On the point of the between, I thought that between x and y was quicker than > x and < y.

Therefore a more verbose date would result in a...

What are the time gaps between full, 1st and 2nd differential backups?

Is the database under heavy or light usage?

It is also the DBA which will deal with all the problems which can occur with Transactional Replication.

The DBA should therefore have enough access and responsibilty to both sides for...

Ensure the first log backup is restored with NO RESTORE. This enables the second Log Backup to be applied.

Transactional replication uses the snapshot agent to initialize the replication. There is no easy way around this.

However the workload for this is not significantly greater than...

Apart from the numerous exploits of people telling me their computer is completely broken and not working at all (well actually it boots, loads word etc but gives an error...

To be pedantic, you are not compelled to retake your driving test in the UK unless the court orders it, which they normally don't. If you re-offend within 10...

I have never really understood the MS insistence on this one.

As previously mentioned most of the revenue must be from companies not from home users.

Secondly surely having a...