Eirikur Eiriksson - Friday, January 20, 2017 12:40 AM
Those are server-level settings so the sp_configure must be run by a member of the sysadmin role, also RECONFIGURE WITH OVERRIDE is needed for updating the Running Configuration Value. 😎
Guess you meant How to restrict user's access 😉
I have done with Override as well, but no luck Yes i meant to restrict user lever access only , but which option i need to opt