Research on cpu100% Problem of SQL2005 database query in Project management system

[a basket of rice special thin Original, reproduced please indicate from http://www.cnblogs.com/wanghafan/p/4595084.html]

Query engineering details appear in the project management system cpu100% symptoms:

1. Open Profiler trace Discovery [F_getprojectsum_detail] function card dead

2. Run the statement separately " database error: An error occurred while performing the batch processing. Error message: Directory name is invalid "

3. Click "Show estimated query plan" (if there is no SQL toolbar right-click to display it), the result is prompt documents and settings\xxx\local
The settings\temp\1\xxx.tmp file cannot be accessed.

4. View found no 1 This subdirectory-this is a temporary directory for the 1th remote connection session, manually create a subdirectory 1, you can query the normal

Research on cpu100% Problem of SQL2005 database query in Project management system