HI All,

As per the article I have created the AUDITLOG table and also created the trigger.

But when executed some DDl commands the AUDITLOG table is not working as expected.

CREATE TABLE dbo.test55(col INT)

GO

DROP TABLE dbo.test55

GO

-- View log table

SELECT *

FROM dbo.AuditLog

ID Command PostTime HostName LoginName

----------- ------------------------------ -------

1 NULL NULL ROOM-5E8A79FFB4 NULL

(1 row(s) affected)

My query is why the command column is not able to capture any event.Has something need to be done to capture the events.

Kindly assist me.

Thanks,

Sandhya