Database Change Log

Is there any way to see what jobs and or changes have been
made to a database. Not the data itself, but things like
indexes, statistics, DB settings, or outside/automated
jobs? I know I can run a trace to see real-time actions,
but I'm interested to see what may have happened overnight
or yesterday. Any help would be greatly appreciated.
Thank you,
Heidi
Some stuff are logged in the errolog file. You can also configure each SQL Server message to say
whether it will go to the errorlog file. However, DBCC DBREINDEX, for instance, doesn't return any
messages. You can check the Agent log, but that will not catch of someone does it from outside
Agent. Depending on your situation, your only option can be Profiler, or some audit tool reading the
transaction loge (see my links page about log reader tools).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hdsjunk" <anonymous@.discussions.microsoft.com> wrote in message
news:0d3801c49c0d$a14666b0$a301280a@.phx.gbl...
> Is there any way to see what jobs and or changes have been
> made to a database. Not the data itself, but things like
> indexes, statistics, DB settings, or outside/automated
> jobs? I know I can run a trace to see real-time actions,
> but I'm interested to see what may have happened overnight
> or yesterday. Any help would be greatly appreciated.
> Thank you,
> Heidi
sql