Microsoft – SQL Server – Management Studio – Error Message – An error occurred while executing batch. Error message is: The directory name is invalid.

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.

Please note:

  1. 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.

References:

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s