Scalar-valued Functions [dbo].[IsXLedgerInUse]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
/**
* Determines if the XLedger accounting system is in use (i.e. is actively being used)
* as the de facto accounting system.
*/

CREATE FUNCTION [dbo].[IsXLedgerInUse]()
returns bit
as
begin
    return convert( bit, isnull( (
        select top 1
            case dbo.GetBooleanVarChar( [Value] )
                when 'true' then 1
                else 0
            end
        from GlobalSystemOption
        where [Name] = 'XLedgerExperimental'
    ), 0 ) )
end
GO
GRANT EXECUTE ON  [dbo].[IsXLedgerInUse] TO [MssExec]
GO
Uses
Used By