建立AUDIT表和触发器,建立STREAM表和触发器

在数据库中针对Locations执行系列SP
EXEC spSqlBuildAuditTable 'Locations'; --必须有
EXEC spSqlBuildAuditView 'Locations'; --必须有
EXEC spSqlBuildAuditTrigger 'Locations'; --必须有

EXEC spSqlBuildAuditTable 'Locations_cstm'; --必须有
EXEC spSqlBuildAuditTrigger 'Locations_cstm'; --必须有

必须有先AUDIT功能才有STREAM流

EXEC spSqlBuildStreamTable 'Locations';
EXEC dbo.spSqlBuildStreamView 'Locations';
EXEC spSqlBuildStreamTrigger 'Locations';
EXEC spSqlBuildStreamProcedure 'Locations';
EXEC spSqlBuildStreamFunction 'Locations';
EXEC spSqlBuildStreamData 'Locations';

posted @ 2018-04-04 08:50  emmaKang  阅读(188)  评论(0编辑  收藏  举报