Exec sp_addlinkedserver @servername = 'CMSSERVER\SQLEXPRESS', @srvproduct='SQLServer OLEDB Provider', @provider='SQLOLEDB', @datasrc='CMS_Syllabus'
select * from CMSSERVER\SQLEXPRESS.CMS_Syllabus.dbo.Admin_Details
select * from OPENQUERY([CMSSERVER\SQLEXPRESS], 'select * from CMS_Syllabus.dbo.Admin_Details')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)