May 4, 2002 at 11:05 am
We move our SQL 7.0 database to a server with dual processors and we had a stored procedure that quit working. We tried it on another server with dual processors and it still did not work. We removed one of the CPUs and it worked. Does anyone have any ideas as to why this is happening? We need to use dual processors.
May 4, 2002 at 2:09 pm
I'm not quite sure why it stopped working due to multiple processors, it could possibly be because it's trying to create a plan involving parallelism and it's not able to. Is this the only stored procedure not working? Does it return an error?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
May 5, 2002 at 7:29 pm
This is an odd situations. Have any other procedures been affected? And can you explain what it does?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply