June 14, 2009 at 7:30 pm
I just upgraded from SQL Server 2000 to 2008 and am running into an issue with xp_cmdshell. I run a few different programs with it and they all seem to work fine unless they use Microsoft Word, in which case I get this error:
There is insufficient memory. Save the document now.
They all worked on the old server and I can run the programs fine from command prompt. Any ideas?
Thanks
June 15, 2009 at 10:37 am
This may seem like a silly response, but in 2008 xp_cmdshell is disabled by default. I found an article that shows how to enable it. http://blog.sqlauthority.com/2007/04/26/sql-server-enable-xp_cmdshell-using-sp_configure/ I am guessing you already tried this, in which case disregard.
June 15, 2009 at 10:50 am
Are you calling Word from within xp_cmdshell? I haven't seen this, but it sounds as though you might be out of memory on the server. I'm not sure the xp_cmdshell calls run inside SQL Server. I think they start a new process, and if SQL is taking most, or all, of the spare memory on the server, you could have issues with things like Word.
June 15, 2009 at 12:55 pm
I definately have xp_cmdshell enabled, it works fine for other programs. I don't think it ever has really been a memory issue as it doesn't take much and I have enough to spare to run it easily.
I changed versions of Word and now I'm actually getting a different error.
The document name or path is not valid. Try these suggestions.
* Check the file permissions for the document or drive.
* Use the File Open dialog box to locate the document.
The problem is similar to the problem described in this post http://www.dbforums.com/microsoft-sql-server/1117094-strange-xp_cmdshell-permissions.html except that I'm using C# and Word instead of Perl and Excel.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply