Thanks for the reply Steve,

The following options are set:

trunc. log on chkpt.

torn page detection

auto create statistics

auto update statistics

Is auto-close a kulprit to this kind of problem? 

Aaron

Namaste ji,

I just found this in the help:

'Assignment operation between table variables is not supported. In addition, because table variables have limited scope and are not part of the...

I appreciate your efforts Lowel and look forward to anything you may find.

kind regards,

aaron

lucky,

here is how i have formatted some timedate information.  you can modify an necessary.

                LEFT(

                    CONVERT(VARCHAR,

                        GETDATE(),101) + --DD/MM/YYYY

                        LEFT(RIGHT(CONVERT(VARCHAR, --HH:MM:SS

                            GETDATE(),109),15),9) + SPACE(1) +

                        RIGHT(CONVERT(VARCHAR,

                            GETDATE(),109),2),...