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