Does anybody know where I can find a list of all the parameter options for sp_configure? It isn't really jumping out at me when I search online for possible variations and the capabilities of sp_configure.
Thanks!
Sql-server – SQL Server sp_configure options
configurationsql serversql-server-2008
Related Question
- MS SQL Server – ‘cmd’ Field Definitions in sysprocesses
- SQL Server – Searching for X at the Beginning of a Line in Multi-Line String
- SQL Server – How to Temporarily Change Settings for a Task
- SQL Server Restore Options Page – A Comprehensive Guide
- Sql-server – Is it possible to change the SQL Server errorlog file number on Linux
- Sql-server – SQL Server sharing drive location
Best Answer
At least three times on the sp_configure page, you have "Setting Server Configuration Options".
This page also shows what happens if you run
sp_configurewith a blank@confignameThis applies from SQL Server 2000 to SQL Server 2008 pages