create linked server to an instance

EXEC sp_addlinkedserver @server = ‘LOCALHOST’, @srvproduct=”,
@provider=’SQLOLEDB’, @datasrc = ‘SERVERNAME\INSTANCE_NAME’, @catalog = ‘HR_Smart_Control_MetaData’

Leave a Reply

Your email address will not be published. Required fields are marked *