MS SQL Management Studio Error: An error occurred while executing batch

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hi4murali
    New Member
    • Oct 2007
    • 1

    MS SQL Management Studio Error: An error occurred while executing batch

    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 does not occur if the Results To File or Results to Text are enabled. This problem has just started now, otherwise has been working fine previously

    Have checked http://forums.microsof t.com/TechNet/ShowPost.aspx?P ostID=1430038&S iteID=17 - but this is not the case of the problem.

    Let know you have any idea as to why this occurs.

    Thanks, M
Working...