Posted by rawheiser on 08/17/06 23:22

Thanks for the link, I will look at it for future issues.
(and browse about your site for other goodies).

I did find the problem,
though I am not exactly sure of the mechanism involved.

The outer procedure was calling a procedure
that a procedure three levels down was also calling,
when I removed the duplicate updating,
it then flew like the wind.

I also changed a Set NoCount OFF to ON, which may have helped as well.

The proc is called by SQLAgent,
and I'm not exactly sure where all that 'client chatter'
goes to when the server is running the process.
(the NULL device?).

• Next in forum: Alter a SQL table
• Prev in forum: Re: Best way to move datafile from C drive to D
• Thread view: Re: After SP4, proc w. Cursor doesn't release keylocks

[Reply to this message]