1.In SSMS, Expand Server Objects -> Linked Servers -> (Right click on the Linked Server Folder and select “New
2. The “New Linked Server” Dialog appears. (see below).
3. Enter the security option of your choice.
4. Click OK, and the new linked server is created
Create view ..
create view [dbo].[devmagicordercreation] as SELECT SKCLRef, Buyerref , style ,Comments, Receivedate, Submissiondate
FROM MD_SIR.DevelopmentMagic.dbo.SampleOrder
Create view ..
create view [dbo].[devmagicordercreation] as SELECT SKCLRef, Buyerref , style ,Comments, Receivedate, Submissiondate
FROM MD_SIR.DevelopmentMagic.dbo.SampleOrder
