How to/ is it possible to:
configure the execution time out at the sql user level?
I have tried to view the connection properties and see the execution time out value but all the connection properties are greyed out - both as an existing user and as a new user.
What am I trying to accomplish?
I have long running queriers and the server is set to a default timeout of 600 seconds. That's fine, but for sql users that the website utilizes, I want the execution time to be much shorter. THe sql execution time out setting should not exceed the web server's page load timeout setting - and that doesnt need to be 600 seconds, it shoudl be no more than 90 seconds, and even that is at the high end of how long I would expect a person to wait for a page to load.