For me the person who most embodies the definition of hero, is Lenny Skutnik

I remember when the Air Florida plane hit the bridge across the Potomac in Washington on...

Referring to anyone as "halfwit" shows you to be a poor human being, and probably explains why you have problems.

Fitting name by the way.

Thanks Jesper, you is the man.

I knew of the REPLACE function, but hadn't thought about the fact that tab & newline have char values.

I really appreciate your help, many thanks...

Hi Greg, see my reply to Bill Turner's post on the same subject... don't know if this helps you.

best regards,

Tim

Hi Bill,

I can't see that you can do a SELECT TOP n like you could in 2000, but you can do this:

Right-click  tablename> OPEN TABLE

Right-click in RESULTS PANE >...

Hi AJ,

Please can you confirm that you have enabled Database Mail OK and that it is JUST the @QUERY parameter that is throwing things out for you?

Do other sp_send_dbmail queries...

Cheers Markus! I'll get used to it eventually.... still having trouble working my way round BOL....

Kids are like farts. You can stand your own, but nobody else's.......

(People with kids will appreciate that one!)

DOH!! Bored AND stupid!

Can you see it now? Revel in the luxuriousness of that mane....

Merry Crimbo by the way!

I think we all know nerds who are FANTASTIC at SQL, but can't muster a decent conversation with their workmates.  It's all about being human, being a good person -...

For me, it's Michael Palin as Pontius Pilate in LIFE OF BRIAN trying to keep a straight face when berating the soldiers for laughing at his friend's name (you know the...

Do you mind if I borrow your soapbox? I've got a pile of soap that needs tidying away.....

Each book has a statement of copyright in the first few pages - to ignore it and copy it anyway and wait for someone to complain is the height of...

Also, if any of you lot ever use my keyboard, PLEASE DON'T EAT AT THE SAME TIME....

I'm really enjoying this spleen venting...!!

Tim

Derek,

I stand to be corrected, but I really don't think you need the NTAUTHORITY\NETWORK SERVICE login in SQL SERVER. Why do you think it needs to be in there somewhere?

I...