Sigerson (11/27/2012)
Jeff Moden (11/14/2012)
Did you make sure the linked server is "read only"?
How can you tell whether a Linked Server is read only. I looked for a 'read-only' flag and didn't find it under that name. I am linking a case management system to our main accounting system and I need to *sure* that I won't update accounting. Ever.
By making sure the account used for logging on to the other server only has read permissions.