Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Who create database

Author  Topic 

chih
Posting Yak Master

154 Posts

Posted - 2010-12-28 : 16:16:54
Hi All,

Is there a way to find who created the db?

someone created a db and changed the owner to sa. I would like to find out who did this. Is there a log?

Thank you so much

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-12-28 : 16:24:53
Right-click on the database in question, select Reports | Standard Reports | Schema Changes History.

That report looks at the default trace to get its information.

Jeff
Go to Top of Page
   

- Advertisement -