I need to know the action behind the binary string, and not just to convert the info in binary field to text.

Any ideas?

@Emperor100

In this case, I suppose neither the file with just headers would be exported, correct?

So, what kind of privileges should be given?

Thank you, it works fine for me too.

Thank you for your answers.

The EXEC command returns the same error, I had already tried this.

I don't want to create the object on the second database, cause my query is...

Thank you very much, I have already solved the issue.

I don't intend to argue in any way, I am just trying to find a solution. And yes, I have a second option to do my job, but I would...

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 to...

Any solution from someone?

I am getting the attached messages, executing the command on SQL and CMD.

Of course I read what you said, and I checked the link.

As I said, it has nothing to do with sybase bcp command, and also the specific command brings an...

@frederico_fonseca It's not a sybase command, it's a classic dos command executed through SQL server with the xp_cmdshell command.

@mike01 I am executing the command in one...

Yes, it has access to this path. Also, I have given access to the bcp.exe for the SQL service and still the problem remains.

It's not syntax error, cause as I said the command is running normally from CMD.

The code is above.

declare @cmd nvarchar(4000)

set @cmd = 'bcp "select ''Field1'', ''Field2'' union all select Field1,...

Thank you Rajattechno for your answer.

I don't think it has to do with a damaged or corrupted installation, but maybe a permission issue or something like that.

Any other ideas?

Thank you.