CODEWITHSUNDEEP
sqlsql-server-2012
GordyII
GordyII

Reputation: 7257

SQL Server 2012 Read Only Connection

How can I setup a read only connection to sql server 2012 without the need to create a read only user?

Upvotes: 8

Views: 5724

Answers (1)

Tony Shih
Tony Shih

Reputation: 436

Connection String property ApplicationIntent

From the docs:

Declares the application workload type when connecting to a server. Possible values are ReadOnly and ReadWrite. For example:

ApplicationIntent=ReadOnly

Upvotes: -1

Related Questions