CREATE TRIGGER TR_PASS
ON DATABASE
FOR CREATE_TABLE,ALTER_TABLE ,DROP_TABLE
AS
DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL=EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')
EXEC('USE DBTEST2;'+@SQL)
GO
ON DATABASE
FOR CREATE_TABLE,ALTER_TABLE ,DROP_TABLE
AS
DECLARE @SQL NVARCHAR(MAX)
SELECT @SQL=EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')
EXEC('USE DBTEST2;'+@SQL)
GO