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.
| Author |
Topic |
|
ramaiah
Starting Member
27 Posts |
 Posted - 2011-01-13 : 10:22:18
|
| Hi,I have SQL Server Instances 2008,2005. I would like to know who is created/deleted a database on my instance?Can anyone suggest which is the best method for this Can I use Audit Triggers or 2008 Auditing mechanism.Thanks in Advance. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-13 : 10:25:11
|
| If you haven't disabled it, that is captured by the default trace, which is typically located in the \MSSQL.1\MSSQL\LOG\ directory in the installation path (for SQL 2005) and \MSSQL10.MSSQLSERVER\MSSQL\Log\ for SQL 2008. |
 |
|
|
|
|
|
SQL Server Audit in 2008