Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Read-Only Linked Server

In SQL Server 2012 how do I create a read-only linked server. The following does not seem to be working:

EXEC sp_addlinkedserver
@server = N'SALESFORCE-RO',
@srvproduct=N'DBAmp',
@provider=N'DBAmp OLE DB Provider',
@provstr=N'ApplicationIntent=ReadOnly';
1 person has
this question
+1
Reply