Considering I am making a full backup - why wouldn't the transaction log be cleaned out at that time ? Why do I need to do something extra ?

...

I created a stored procedure and was able to log the data I wanted !!! Thanks !!!

I don't think it is permissions cause the job executes. It successfully picks up files from one directory and puts them in another directory. It just doesn't stop...

Ah, so it is just a visual problem. Thanks Andy !!!

I get this error even if a I do use a parameter marker with a while loop and the SQLPutData command to chunk the data. I have not tried...

How do I do a standard insert for a file ? If I use the following command isn't the file path going to be inserted rather than the content...