Displays Configuration option references and current set values.
2001-08-22
714 reads
Robert-Vallee,
2001-08-22
Displays Configuration option references and current set values.
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
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads