I need to append records from a linked table coming from two different servers. It says to do a set identity_insert <table_name> on via a sql passthrough query. How to do this when I open the said query?
Thank you.