I have a production SQL instance "Host1\SQL1" and a testing SQL instance "Host1\SQL2". I've trying to copy data from the Production SQL instance to the testing SQL instance, like this:
(but it isn't working) What as I missing?
(running SQL from "Host1\SQL2")
SET TemplateText =
FROM [Host1\SQL1].MyDB.PageTemplates AS PT1
WHERE (PT1.TemplateID = 1))
WHERE (TemplateID = 1)