November 5, 2010 at 12:24 pm
Hi,
I could see one new database created in our dev server.
Is there anyway to know who created that one?
we are using sql server 2005 version
November 5, 2010 at 12:40 pm
I think the default trace might have it, if it's not overwritten yet.
" ... As you can see, we were able to gather some pretty significant information about who created the database and when the database was created ... "
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
November 5, 2010 at 1:35 pm
Yes, absolutely. Assuming the default trace hasn't been overwritten, that's exactly the type of information it captures.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 5, 2010 at 1:47 pm
Unless it is changed after creation, the database owner will be the userid who created the database, so check that.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply