Split reads to a different connection string

Anyone know if there’s a way to catch the database connection object, and change the connection string under it? Basically I want to redirect the commands that don’t have the words INSERT, UPDATE, DELETE, EXECUTE or EXEC to another server name which would be a load balancer of sorts.

I browsed the docs, but couldn’t find anything that looked right. That said, I’m not a developer by trade.

Read more here: Split reads to a different connection string

Leave a Reply

Your email address will not be published. Required fields are marked *