Microsoft – SQL Server – Management Studio – Error Message – An error occurred while executing batch. Error message is: The directory name is invalid.
This error message is usually due to an incorrectly setting for the environment variable “TEMP”.
Check the setting for the Environment variable, create if not available, and ensure that your account has full permissions to this folder.
- That even though you one can change the environment variable at any time during a windows session, the one that seems to persist for ssms appears to be the setting upon initial session logon.
error message when trying to create any query