prepost! ___________________________________________ .\\axxx (That's an 'M')

And here in the UK we had "bloody awful weather - start of the week day". It's not catchy, and it's not a holiday, but it's ours and we're going to guard this with glee. "WPF has many lovers. It's a veritable porn star!" - Josh Smith My blog | My articles | MoXAML PowerToys

"Entry point for programming" 6 figure salary for Entry point?? Who am I to argue.

If it's SQL Server, use the instead of trigger. SG Cause is effect concealed. Effect is cause revealed.

True, but that Validate function is still easiest to read if it has multiple return false statements for each error check that fails and one final return true at the end if it passes all the tests. Regardless of where the error checking is, I always find it more readable to do it this way rather than massively nesting the multiple error checking to force the routine into only having a single exit point - the OP's original point. Judy

cp9876 wrote: seems to be never Really? Gee I must be sleeptyping again. :laugh: Luc Pattyn [Forum Guidelines] [My Articles] this weeks tips: - make Visual display line numbers: Tools/Options/TextEditor/... - show exceptions with ToString() to see all information - before you ask a question here, search CodeProject, then Google

Yup another yes for this book. I have the old one but it is brilliant. The only thing unpredictable about me is just how predictable I'm going to be.

We use TestTrack from http://www.seapine.com which I've used at my last few companies. Todd Smith

No, and this is really the problem, the sql that we are passed could contain largely anything.

Yes, but a man in a wheelchair is quite capable of finding the ramp up to the front door. ;) BW Quick to judge, quick to anger, slow to understand. Ignorance and prejudice and fear walk hand in hand. -- Neil Peart

It's a pretty funny book(s). "110%" - it's the new 70%

I was just going to say that. :P Great minds think alike ;) I'm finding the only constant in software development is change it self.

Ed Gadziemski wrote: But doesn't everyone who knows you eventually reach this point? Probably, I'd ask someone but I'm not on speaking terms with them... Matt Newman

Doesn't really cover for asp using CDO...

Ok - converting the output to nvarchar solved your problem? I'll give that a go...

But then I remembered, I really don't care what most people think. File Not Found

Ok. Just got back to this now. We are using a single connection object that is opened at the start and then closed after performing all the inserts... My trace just shows many Audit Logon messages rather than connection open messages.