Good choice... BCP was definitely the way to go especially since you didn't want header info.  Nice job and thanks for the feedback.

Here's all the things that need to be true to do non-logged bulk inserts from BOL...

• The recovery model is simple or bulk-logged.
• The target table is not being replicated.
• The target...

Cool... Thanks again, Andrew.

Anyone else?  It would be really cool if this could be done through T-SQL without modifying SysProcesses directly... don't think it can be done but its worth asking...

Daaaang... thanks, David Coming from the likes of you, that's quite the compliment.

Heh... and I was too sleepy this morning... I shouldn't post when I'm pooped...

It is still a bit of a half cross...

Ok... I was right about the cross-join... and it took more than 3 minutes to exec on 100,000 rows.

And when I change that snippet in the function to have a...

Sure thing, JH... I don't like the looks of that unconstrained cross-join in the function, though... I think it's going to gen 65,536 internal rows every time it executes...

I'll...

I agree... so far as I'm concerned, writing directly to SysProcesses is not an option but a sub for OSQL may be what I have to find (or build).  I...

Hey, Richard... just to let you know... I can normally beat most looping functions by using a Tally table... but not this one (least ways, not so far

Thanks for the response, Andrew.  Yeah... kinda missing what I'm asking for.  OSQL doesn't have a "connection string" nor a paramter for it, but the security folks want me to...

Comin' right up...

There's a function in SQL specifially designed to handle IP addresses and similar naming... your instructor probably told you about it. 

Never mind... I found it... should I tell him about the function that's specifically designed to take care of IP addresses?  NOT!!!

Sorry Gail... operating on my first cup of coffee Do you have the URL for that?

I share the same thoughts.  You've certainly got the right idea about improving your own skills.  Even though I've been doing this for a while, I still learn new things...