USE [master]
GO
EXEC sys.sp_addlinkedserver
@server = N'Production',
@srvproduct = N'',
@provider = N'SQLNCLI',
@datasrc = N'127.0.0.1,1713'; -- fix this up for your IP and port
Then you can drop and recreate it as needed:
USE [master]
GO
EXEC master.dbo.sp_dropserver
@server = N'Production',
@droplogins = 'droplogins';
GO
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato