Viewing 15 posts - 1 through 15 (of 25 total)
Thank you, it works fine for me too.
July 9, 2021 at 3:42 pm
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...
July 9, 2021 at 3:10 pm
Thank you very much, I have already solved the issue.
May 12, 2021 at 12:25 pm
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...
April 6, 2021 at 7:50 am
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...
April 5, 2021 at 12:06 pm
Any solution from someone?
April 1, 2021 at 8:04 am
I am getting the attached messages, executing the command on SQL and CMD.
April 1, 2021 at 5:35 am
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...
March 31, 2021 at 8:11 pm
@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...
March 31, 2021 at 7:07 pm
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.
March 31, 2021 at 3:13 pm
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,...
March 31, 2021 at 10:10 am
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.
March 31, 2021 at 7:06 am
No hide.
I need the user to be able to make a right click at a db object (table/view), press "Select top 1000 rows" and the SSMS query editor to bring...
May 28, 2020 at 4:21 pm
No object in msdb he is accessing.
Just because the user is only mapped to one database (and not system) and only there he has access, he cannot make a selection...
May 28, 2020 at 3:52 pm
Thanks for your answer.
There is only one database (not system) that is accessible, and it's objects are the ones that concern me, so no other database concerns me.
I want to...
May 27, 2020 at 7:37 pm
Viewing 15 posts - 1 through 15 (of 25 total)