USP_SIMPLELIST_AUDITEDTABLES

Definition

Copy


create procedure [dbo].[USP_SIMPLELIST_AUDITEDTABLES]
with execute as owner
as

-- Return all valid tables as well as an "All Tables" option.

declare @TABLENAMES table (TABLENAME nvarchar(max), ENABLED bit);
insert into @TABLENAMES (TABLENAME, ENABLED) values ('All Tables', 0);
insert into @TABLENAMES
exec dbo.USP_AUDIT_GETTABLELIST;
select [TABLENAME] as [VALUE] from @TABLENAMES;