Post reply

Capture who created the Database

  • August 21, 2012 at 4:20 pm

    #392998

    Hello,

    I have requirement where I need to know who had created a database. I know that I need to use Object:Created event to find it.

    But it gives a ton of rows. As it will capture every object created. Well upon googling I found out that I needed to look at ObjectType '16964'.

    But Its difficult to understand what object is created. I am not able to properly decipher what is being displayed.

    Can any one please help with a query you might have come up on the default trace to capture this event.

    Thank u.

  • August 22, 2012 at 1:40 am

    #1528475

    Create a DDL trigger for the CREATE DATABASE event and get it to log to a table, that way you dont need to have a trace running, it is captured at DDL execution.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply