Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bkstroud99
Starting Member
2 Posts |
 Posted - 2012-05-03 : 21:59:50
|
| I am trying to create a bulk copy using the following code:EXEC xp_cmdshell 'bcp Project_customerDB..pCustomer out C:\CSCProjects\customers.dat -T -c'I was able to run the command fine the first few times, but now I am getting this error when I try to execute it:An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '1018'.I did not change anything to the code. I did try to add the servername to the end of the code after this error began, but I continue getting the same error. Any ideas would be appreciated. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 22:08:33
|
| did you check access permissions on file? it might be a permission issuealso did you chenge any security settings of late?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
bkstroud99
Starting Member
2 Posts |
Posted - 2012-05-07 : 12:15:09
|
| I didn't change any permissions. It worked one night and the next night it didn't |
|
|
|
|
|
|
xp_cmdshell error code 1018