http://sqlserver.ro/blogs/cristians_blog/archive/2007/12/30/pop-quiz-set-options-in-triggers.aspxIt started with this question: Let's suppose that I want override the QUERY_GOVERNOR_COST_LIMIT value for an user that connects to the server. How can I do that? I want to customize the value per user so I won't use sp_cofigure and query governor costenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/blogs/cristians_blog/archive/2007/12/30/pop-quiz-set-options-in-triggers.aspx#3709Wed, 02 Jan 2008 15:52:57 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:3709xmldeveloper<p>Since there are no answers, I will give the answer myself:</p> <p>[quote from=&quot;BOL&quot;]</p> <p>If a SET statement is run in a stored procedure or trigger, the value of the SET option is restored after control is returned from the stored procedure or trigger. </p> <p>[/quote]</p> <p>So, the value will be the defaul one: 0.</p>