Create a linked server through SQL Command

 

Sample SQL query to execute when the database administrator programmatically creates a linked server for ODBC using SQL Server

EXEC SP_ADDLINKEDSERVER @server = 'EVA3', @provider = 'MSDASQL', @srvproduct = 'NetSuite.com', @datasrc  = 'EVAODBC', @provstr = 'DSN=EVAODBC'

EXEC SP_ADDLINKEDSRVLOGIN @rmtsrvname = 'EVA3', @useself = 'false', @locallogin = NULL, @rmtuser = 'sampleemail@noemail.com', @rmtpassword = 'samplepassword'