Thanks for the reply. I was just in the middle of checking this against the execution plans... Cheers for the prompt feedback.

M

How have you allocated to the database log file? Make sure this is set to autogrowth and no file restrictions. and also check the tempdb database to make sure that...

Thanks a million Ramesh

M

I think I may have gotten that but why is the R at the end of the statement?

thanks again?

Hi Ramesh thanks for the reply.

But now I am getting the error

Msg 8159, Level 16, State 1, Line 1

'RecordHeaderCTE' has fewer columns than were specified in the column list.

Any...

Thanks for the input will keep it in mind!

Martin

Oh OK so.

thanks Ramesh

Its the profiler that logs these events, now forgive me if I'm wrong and I could well be but I don't see any way of logging these events unless the...

Folks,

Thanks for your replies. Unfortunately due to the complexity of the system and the value of it(accepts all our payment) it cannot be rewritten so easily. It has been investigated...