![]() |
#6 |
Участник
|
Цитата:
Сообщение от AndyD
![]() У вас там с DDL триггерами не баловались?
X++: /****** Object: DdlTrigger [Audit_Log_DDL] Script Date: 04.11.2015 23:44:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [Audit_Log_DDL] ON DATABASE FOR CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE, CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS Declare @Data XML, @DB VarChar(255) Set @Data = EventData() Set @DB = DB_NAME(db_id()) Insert Into DBMS.dbo.Audit_DDLEvents (EventType, EventXML, TSQLCommand, DatabaseName, SchemaName, ObjectName, HostName) Select EventType = @Data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)'), EventXML = @Data, TSQLCommand = @Data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)'), DatabaseName = @Data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)'), SchemaName = @Data.value('(/EVENT_INSTANCE/SchemaName)[1]', 'varchar(256)'), ObjectName = @Data.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(256)'), HostName = @Data.value('(/EVENT_INSTANCE/ServerName)[1]', 'varchar(256)') GO SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER OFF GO ENABLE TRIGGER [Audit_Log_DDL] ON DATABASE GO |
|
|
|