I ask the person who installed this server.

it was not one time installation.

their steps on the installation is:

(1) install engine, not include management studio and agent service.

(2) install SP 2...

thanks Jeff,

I must use that, because it is a part of promotion of OLD system to new system in our company.

i have to use those old code, the change less...

hi there,

I have solved this problem.

1, create a bat file in DOS root,inside content the sentence to run BCP script.

2, create a task Schedule to run the bat file in...

exec master..xp_cmdshell 'bcp.exe L_Staging.dbo.DID_Data in "c:test_20091118.txt" -f "bcp_DID.fmt" -S "qa-01" -U "sa" -P "Ssssssss"'

SQLState = 08001, NativeError = 2

Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open...