hx_ConfigurationOptionReference

drop PROCEDURE [hx_ConfigurationOptionReference]
go

/* Robert Vallee 04/11/2001
rvallee@hybridx.com
input:None
output:Table format
Desc: Displays Configuration option references and current set values.
Warnings: None
*/
CREATE PROCEDURE [hx_ConfigurationOptionReference] AS

set nocount on
select substring(Comment,1,75) as [Configuration Option Name],
'Status'=case
WHEN master..syscurconfigs.status = 0 THEN 'Static (The setting takes effect when the server is restarted.)' 
WHEN master..syscurconfigs.status = 1 THEN 'Dynamic (The variable takes effect when the RECONFIGURE statement is executed.)'
WHEN master..syscurconfigs.status = 2 THEN 'Advanced (The variable is displayed only when the show advanced option is set.)'
WHEN master..syscurconfigs.status = 3 THEN 'Dynamic and advanced' 
end,
master..syscurconfigs.value as 'Current Value'
from master..syscurconfigs