Facing a strange error in MS SQL Management Studio 2005, when trying to open a new query window, open a table to view data or even run and existing SQL query file. The error text is:

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

After initial investigation, found that this error is thrown when we execute an existing sql query file with the Results To Grid option is set and...