Query logs

Does SQL Server create a log of all the queries run against a database? Or,
alternatively, is there a way to retrieve deleted data from a table?
thnx,
Christoph
No it doesn't keep a log of queries (as in selects) but all dml is recorded
in the transaction log. If you have backups you can restore to a previous
point in time but I guess you don't in which case you pretty much need a
third party tool like Lumigent's log explorer which is able to read the
transaction log and reconstruct deleted data/truncated tables
http://www.lumigent.com/products/le_sql_faq.html
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Christoph" <jcboget@.yahoo.com> wrote in message
news:OhkjsXXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> Does SQL Server create a log of all the queries run against a database?
> Or,
> alternatively, is there a way to retrieve deleted data from a table?
> thnx,
> Christoph
>