[dbo].[IsXLedgerActive]
BUILD09
>
MoversSuite2
>
Stored Procedures
> dbo.IsXLedgerActive
Properties
Permissions
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Permissions
Type
Action
Owning Principal
Grant
Execute
MssExec
SQL Script
CREATE
PROCEDURE
[dbo]
.
[IsXLedgerActive]
AS
begin
set
nocount
on
select
IsActive
=
convert
(
bit
,
1
)
where
dbo.IsXLedgerInUse
()
=
1
end
GO
GRANT
EXECUTE
ON
[dbo]
.
[IsXLedgerActive]
TO
[MssExec]
GO
Uses
[dbo].[IsXLedgerInUse]
dbo