sp_configure

Storing sp_configure settings in a stored procedure

This entry was posted in SQL Server SQL Server code and tagged instance settings sp_configure xp_cmdshell on by

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 […]

instmdb sql file excerpt