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.

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

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

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

Thanks a lot, I 'll try the solutions and come back.

Yes, it's the IntelliSense assistant.
It seems that it's working with a user that owes full access to the SQL server, but not with a user that has read-only access.
I...

I don't mean the third party product, I am talking about the embedded intelligence to SQL.

The embedded assistant in SQL, since version 2012 and above.

Anyone??

OK, so no known issues have been recorded on this.
If so, any information would be helpful.

Thanks for the answer.
In the past, I have faced issues at the linked server regarding the compatibility while upgrading SQL from 2005 to 2008 R2, that's why I am...

The way it was configured as well in SQL 2008 R2.

The job actually does not overwrite any parameters within the ssis package, all parameters are being configured within the ssis,...

I assume it's the package deployment model.

Got it..

When i used for end-of-line terminator instead of \r, it worked.

Thanks anyway.