Sorry to say, I don't like it. I am interested in the technical articles, and now it is necessary to scroll to the bottom to see them. Why not make...

The plot thickens...

I removed the "create table #hold_sp_inner_results" statement, and placed it by itself, and then performed the INSERT INTO/EXEC of sp_inner. Same slowness, unless sp_inner is run by itself...

sorry, she gets paid to make the rules. I get paid to be her loyal servant.

Still, why should an sp_inner call from within sp_outer run slower and have a junky...

I've captured the plans for the good, fast, execution, and the bad, slow one. I can't figure out why it makes different plans, since I'm callling the sp_inner the same...

Well, I can't post the procx, cuz my boss would have a fit. I did fiddle around with them as follows:

1. Within sp_inner, I made all the parameters that appear...

Well whaddaya think about that! I FIXED IT! I removed that lamebrained mcaffee scan mc-agent and mc-update from the system startup, and sqlmangr.exe now works!

That's interesting, what you said about McAfee. I installed the web virus scan a while back, and let my subscription lapse, and can't figure out how to remove it (McAfee)....

Yep, I just rub it (or the icon in the tray) a little with the mouse (without clicking), and poof, it disappears from both the screen and task manager.

I have a similar problem on my w2k server post SP3: I start sqlmangr.exe, and do any mouse click on the form and it disappears. Actually, I don't even need...

Link to download code doesn't work