USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N'LIVESQL', @srvproduct=N'SQL Server' ;
GO

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'LIVESQL', @locallogin = 'person', @rmtuser='person', @rmtpassword='password', @useself = N'True' ;
GO