Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Server: Msg 8642, Level 17

Author  Topic 

mdhingra01
Posting Yak Master

179 Posts

Posted - 2004-09-16 : 14:51:33
My SQL statement gives me the following error anyone seen this before?

Select Zufc.[Bus Line] as Business,Zufc.Servline as Service,Zufc.SubServ as SubService,Zufc.[Function] as [Function],Zufc.rkost as Collator,Kinship.Region,Kinship.Division,Kinship.Detach as Detachment,Kinship.District,Kinship.Area as Policing
into BI..Kinship
From WorkApp..Kinship as Kinship join BI..Zufc as Zufc on Kinship.unit_coll=Zufc.Rkost

Server: Msg 8642, Level 17, State 1, Line 1
The query processor could not start the necessary thread resources for parallel query execution.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-09-16 : 15:59:21
I googled your error and found this thread. Looks like the error goes away if you restart your server.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=uMsr7WBFDHA.1820%40TK2MSFTNGP12.phx.gbl&rnum=3&prev=/groups%3Fq%3D%2522Server:%2BMsg%2B8642,%2BLevel%2B17%2522%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3DuMsr7WBFDHA.1820%2540TK2MSFTNGP12.phx.gbl%26rnum%3D3

Sorry for the ridiculously long URL...



-ec
Go to Top of Page
   

- Advertisement -