It is not a problem with insert itself. If you run my script without dmo part insert works fine. Also from my experience, if I want to insert from linked...

Now, when I used NT login in QA , the script connects to linked servers but insert statement to the table on local server does not work. I've tried to...

I tried to use your script but I have some security issues (I think) with connectivity to linked servers. All my linked server have the same remote logins:

local sa              remote sa

domain\sqlserviceaccount remote...

I found my answer: sp_helpsrvrolemember.

This is correct, also in sysusers table there is a column 'isaliased' and for \test has value 1.

Thanks a lot.