SQL Server - An error occurred while executing batch. Error message is: The directory name is invalid.

Question

Our database server had run out of disk space, after freeing up some disk space any query run in sql server management studio, with the results sent to grid view, resulted in this error:
An error occurred while executing batch. Error message is: The directory name is invalid.

When the results sent to text view the queries worked fine.

Does anyone know why this error occurs and how to get rid of it?

Answer 1

I know it can sound like a joke, but have you tried restarting SQL Server instance?

Answer 2

Is the "Default Location for saving Query Results" set to a valid path in Tools/Options/Query Results/SQL Server/General?

Do the TMP/TEMP environment variables point to valid directories?

Reinstalling the client tools will probably fix the problem.