Thanks Jeff,

It is working without TABLOCKX anyway so I am not going to lose any sleep over it.

JK

No, the isolation level is the same in each: read committed

JK

Hi,

I have set up a derivative of the above function on several databases and worked fine. On the last database I got the error:

Msg 4138, Level 16, State 1,...

Thanks Wayne,

Works a treat - Although you have explained it, I don't really understand what is going on with your script - I'm sure I could apply this elsewhere. Something...

Hi Lutz,

The solution you provided is what I am after, but I can't get output.

The data that I have provided is drilling information: the DFROM and DTO...

Thanks Lutz,

This works well. Appreciate your time.

JK

Hi,

I think you are right - renaming the file would be neater. I will change my approach. I got this far with the folder option, but am having...