1

Topic: Help to understand please with the job from a packet.

I can not understand where it is specified under what user should will be fulfilled request.
UPDATE cash. DiscountCardCategory
SET Name = ASD.NAME
FROM (SELECT CODE, NAME
FROM OPENQUERY (CENTRUM, ' SELECT CODE, NAME FROM [SES_CENTRUM]. [dbo]. [DiscountCardCategory] ') AS derivedtbl_1) AS ASD INNER JOIN
cash. DiscountCardCategory ON cash. DiscountCardCategory. Code = ASD.CODE
WHERE (cash. DiscountCardCategory. Name <> ASD.NAME) OR
(cash. DiscountCardCategory. Name IS NULL)
Prompt where to look please.

2

Re: Help to understand please with the job from a packet.

Staxs wrote:

Prompt where to look please.

if a question about update to look there where it is fulfilled, and if about openquery, in properties  servers "CENTRUM"

3

Re: Help to understand please with the job from a packet.

And where properties of the server are viewed??

4

Re: Help to understand please with the job from a packet.

ssms - <your server> - server objects - linked servers - centrum - <> - properties - security