Code
EXEC sp_addlinkedserver
'Server',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=192.168.1.2;UID=sa;PWD=sa;'
GO
EXEC sp_helpserver
EXEC sp_dropserver 'Server'
GO
EXEC sp_addlinkedserver
'Server',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=192.168.1.2;UID=sa;PWD=sa;'
GO
EXEC sp_helpserver
EXEC sp_dropserver 'Server'
GO