CREATE TRIGGER LogNewTable
INSERT INTO dba.DatabaseOperation
N'A new table was created', GETDATE())
whenever new table is created in the current database and trigger get fired and name of the user who created the table ,date time the table was created .these information
stored in the logtable..