To add server using sp_addlinkedserver

Question

I tried to insert values from one server to another server and I got the error:

Msg 7202, Level 11, State 2, Line 1 Could not find server 'SNRJDI\SLAMANAGEMENT' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Answer 1

I got it. It worked fine

Thank you for your help:

EXEC sp_addlinkedserver @server='Servername'  EXEC sp_addlinkedsrvlogin 'Servername', 'false', NULL, 'username', 'password@123'