Sqlserver 2005 -  The directory name is invalid.

Posted on 2013-01-07
Last Modified: 2013-01-07
Hello Experts
I am trying to run a query on sql server and get the following error message:

An error occurred while executing batch. Error message is: The directory name is invalid.
Please can someone advise?
Question by:newbie27

Accepted Solution

charlie324 earned 500 total points
ID: 38750451
Usually happens when you are running of disk space ... Did you check it?
LVL 15

Expert Comment

ID: 38750467
Can you post us the query ? please make sure the directory specified in the query (if any) is valid.
LVL 12

Expert Comment

by:Saurabh Bhadauria
ID: 38750482

Author Closing Comment

ID: 38750492
Thanks - it was due to the disk space. Its back on now.

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Change variables in SQL table 6 87
Sql Permission 6 59
Pivot Query Problem 9 41
Upgrading SQL 2005 Express to 2008 R2 Express 31 86
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Sending a Secure fax is easy with eFax Corporate ( First, just open a new email message. In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now