EXEC sp_addlinkedserver

@server ='Link Server Name', -- //mention name for your link server--

@provider = 'SQLOLEDB',

@srvproduct = '',

@datasrc...