Stored Procedures [dbo].[GetGlobalSystemOptionValue]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inOptionNamevarchar(128)128
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
/*
* Description: Gets the value of the GlobalSystemOption that has the specified name.
**/

create procedure [dbo].[GetGlobalSystemOptionValue]
    @inOptionName varchar(128)
as
set nocount on

select
    [Value]
from GlobalSystemOption
where [Name] = @inOptionName
GO
GRANT EXECUTE ON  [dbo].[GetGlobalSystemOptionValue] TO [MssExec]
GO
Uses