Durai,

Thanks for the reply. The previous poster (GSquared) made a valid point. Any tips you might have should probably be emailed.

The person will be a DBA only,...

David,

I used

SELECT * FROM sysprocesses WHERE open_tran = 1

I saw CPU with 131579, or something like that. Big number. The User ID was for the external...

If the Inner Transaction has a Try/Catch/Rollback, but runs fine, commits, exits to the outer proc, and then the Outer proc fails, the Inner Proc, since it successfully (I...

His "CrashProc" runs fine every time. Its when the control goes back to the Outer Proc and runs the next statement, which is an update statement, that we get...

The proc runs fine when he feeds the Update statement a good value. It was in testing that he discovered the interested Error messages. Either way, I though...

Ok, so I put the wrong one in the subject :doze: you get the idea.

The answer is that I'm using RDP. I didn't know that would cause...

Actually, the CTRL+C works, but only sometimes... Ctrl+K doesn't work at all... CTRL+K+K puts a little blue square next to the line.. that's weird.. never seen...

Yes, Exactly.

D'OH! I just noticed that Disable is greyed out and Enable is "clickable".... I should have seen that.....

Thanks Dude!

Crusty.

:ermm: :unsure:

I'M WRONG!!!! OK! I ADMIT IT!!!!! SOMEONE GET A BOWL OF CROW FOR ME TO EAT!!!!

oK.. TONS of research later and I realize my hang up....

HOLD ON HOLD ON... I'm about to post my "I'm an IDIOT" reply....

Wait for it.

Correction, not the plan, but the Query Execution....Logical Query Processing Plan...

OK... dba says something else is going on, so I'm going to believe him.. BUT.. he also said there could be an issue with the execution sequence which is what...

OMG

I am so not on my game these last couple days... Do men get MENapause?