It worked. Thank you. I had to change the file Id to 1 for the second file bizarrely but it worked.

Thank you. I will test it on my development box and let you know if this works for me

Just run regularly with a job:

select * from sysfiles

and you can grab the size of your current log.

Hey guys,

This is very interesting. The where statement influencing the quesry optimization.

Let's get real!!!! MIcrosoft is very stupid... they can have had forecasted that; adding a where statement just to...

Thank you NPeters,

People love to use big vocabulary when it is unecessary. I am with you.

What a stupidity! Let's get real and let's speak in English! Only DBA with complex...

Yep!

That is true.

BCP is great and DTS is rather slow. It is however very easy to develop and gives more elements, easily "writable".

sorry I did not read well. You cannot really do that in a pass-through query. Access is limited, you should know.

However, what I often do , is set up a...

in your pass-through query, you should say

Exec UpdateInfo '1432'

and that should work.

You have to set up properties for the connection in your pass-through query, do not forget that.

quote:

---

I'm way down South in Birmingham, AL and am making $78K/year. Judging by the papers a DBA position goes from anywhere...

I was DBA/developer in Boston and made K65. However my job was very interesting (more developing than administrating) and I was not working more than 8 hours a day, sometimes...