SQL Server execution command appears "invalid directory Hint"

Exception handling Rollup-database family http://www.cnblogs.com/dunitian/p/4522990.html

It is generally clear that the rubbish has been cleared and the directories that should not be deleted are deleted.

Online statement:

Problem Description:

1. SQL Server Open Table prompt: Invalid directory name

2. Prompt when executing SQL statement: An error occurred while performing the batch processing. Error message: Directory name is invalid

3, all the database has 1 and 2 problems

Problem Analysis:

1. The operating system has been re-installed or the system image restored, causing the folder in the Temp directory to be lost.

2, anti-virus software mistakenly deleted.

3, be human or other software deleted.

Solution:

1, write a simple table query statement, click on the toolbar to display the estimated query plan button, the results prompt documents and settings\xxx\local settings\temp\1\xxx.tmp file can not be accessed.

2, manually create sub-directory 1, the database can be restored to normal.

My question is a bit strange, my machine is necessary, and later I use another computer to connect my computer, found everything as usual, and there is no useful diary

Attracted by the wonderful play of a box

Then I went to find this diary and found ... I'll try /log 's order when the wood has the catalogue.

Because the computer does not install VS, just SQL Server, and then try the following command: = = "start running = =" "ssms/log"

And I found out that it was good ....

Speculation should be appenv this directory by the garbage cleanup software to delete the ...

SQL Server execution command appears "invalid directory Hint"