Valid point!!

thanks for the reply.

I did think of a flag but that would mean FE changes.

At the moment when the procedure gets the number for the batch processing I don't use...

Thanks for the reply.

So on that note are you able to tell me if it is "Best Pratice" to have a clustered index on a table? (as opposed to...

So Gail, if I understand what you are saying:

If differential sql backups were part of my plan then doing ad-hoc backups will create a new starting point for the differential.

So...

that is correct,

I was always under the belief that all backups are linked to the latest full backup only. so any ad-hoc backups done would break the log chain...

I think that is were I was wrong. I was only using one try..catch block to encompass the entire code.

If you mean use smaller blocks then yes I...

Hi, yes the output file has been created.

I have double checked and when SSMS is connecting to a SQL 2000 DB the 'view' button is enabled and the output...

Hi, the above 2000 example concept works well for the 2000 procs. The production procedures might be say 1000 lines and it is broken into logical parts. When an error...

I must be missing something then because in SQL 2000 the line after the error gets processed hence the @@error can be captured and acted on , yet in SQL...