Hi thx - I managed to work it out myself by trial and error - works great. My next task is try and do it with WINZIP (users want to...

Hi Carolyn

An excellent and simple example though I have a question.

What this does not do seem to do which would be very handy is zip multiple sub-directories that contain files....

Thanks Sergiy.

Could someone explain to me why our company regularly place GO statements within a transaction when called by OSQL? There has to be a reason for this - is...

OK - I've now come up with this which seems to work well, though I do have a few questions that I hope someone might be able to answer.

1. The...

Thanks for the information.

OK - So, if I have a large transaction that consists of multiple different stored procedure calls that output a return value as per the below but...

Thanks both for the information.

I have decided to leave the primary constraints and unique constraints which by definition create indexes on the table creation statements so that the data is...