Hi, I'm sorry but I cannot reproduce the error anymore. I removed a few comments from the sp that calls bcp, and it started working again. The issue...

Did you ever find out why xp_cmdshell only worked intermittently? I have a similar problem, but mine is running BCP and it just hangs. I have to restart...

Thank you so much Henrik!

I know that the original post for this ancient - it's amazing that you are still helping people 5 1/2 years later!

Keep up the good work...

I just installed CU7 on both instances, so the patch level is 10.0.2766.0 (X64).

I have assigned the 'lock pages in memory' right to the 'network service' account that runs sqlservr.exe.

I...

Ok, I've done the following:

installed SQL Server 2008 CU7

allow "locked pages in memory" right to the "network service" account, which is used to start sqlservr.exe

enabled the trace flag -T845 as...

spongemagnet (2/26/2010)

---

Adam Bean (3/24/2008)

---

if you're using sp_MSforeachtable to execute this command for each table it won't be set correctly - even if you set quoted_identfier on. I recently ran...

At the risk of asking another dumb question:

Do you know if I have to install the CU's for the clients as well as the server? That is going to...

Paul White NZ (5/21/2010)

---

Maa421 (5/20/2010)

---

Then do I need to enable AWE on my 64-bit SQL Server 2008 Std/64-bit Server 2003 Std R2/9GB RAM machine? I have read that this...

What do you recommend? I have 9GB. Instance A is usually often and Instance B is hardly used, but needs to be able to process nonetheless.

Paul White NZ (3/23/2010)

---

EdVassie (3/23/2010)

---

Paging is done by Windows. SQL Server cannot tell Windows to page or to not page any of the SQL Server memory. The 'lock...

THANK YOU for a clear and concise explanation of this issue.

I have exactly the same problem.

Does anyone have any ideas?

Now that you mention it...I changed the ODBC connection to use SQL login and gave it permissions, etc. and it works fine now! Thanks so much for the suggestions.

Hi again, do you happen to know how to pass a user id and password to relog? SQL Server won't give me access. Thanks