you are the one that needs to figure that out for your own environment. test test test.

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the...

please don't post same issue twice.

original thread here https://www.sqlservercentral.com/forums/topic/msg-537-level-16-state-3-procedure-recover_truncated_data_proc-line-113-inva

Ratbak already gave you a indication of what you should do - what did you find so far after following those instructions?

that is where some disagree.

on my 1500 production db's 220 have RCSI enabled - and most new db's are being created with it enabled unless the team requesting it ask...

with that server I would change maxdop to 8 (and try out other combinations - 4 6 12)

and CTFP change to 50 - never below 25 unless fully tested and...

then, and as I said on the options, hardcode the path to the SQL Server BCP and do it that way.

easy and fast - just not portable to other servers...

Sorry but this solution is not professional in all terms. Components exist within a server for some reason, and the solution is not always to remove them in order...

basic solutions that any professional should be able to figure out after the issue has been found.

• remove whatever sybase components you have on the server
• change path order
• hardcode...

ohhh.. it does look like I was right after all.

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

what error?

in SQL Server BCP the command works fine and outputs the version of BCP - on other versions of BCP (such as yours) it may error but without its...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

as you didn't read what I said, neither the link, please...

hum. based on the output you gave us you are executing a Sybase BCP command - so either you not using SQL Server or the server you are executing the...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

can you post the code here - without it we can't tell you what you are doing wrong - but normally its a small thing like missing quotes somewhere.

possibly because it is a cluster and it has its own IP - which will be different from the local host (cluster node)

@Sergiy - for sake of consistency can you give your version (condensed) that gives both outputs I gave - and taking in consideration that either today or yesterday could be...