Storing sp_configure settings in a stored procedure
All SQL Server DBAS are familiar with sp_configure to change the instance global settings. However when you need to modify temporarily those settings from within your code, such as storing sp_configure settings in a stored procedure, the process can become awkward You need to store the configuration setting you change […]