HaveTrouble
Programmer
Everytime an SQL statement runs on a table, did SQL log it somewhere ? If yes, how can I view the log ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL event log
- Thread starter HaveTrouble
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
- 0
- 36
every insert, update and delete is written to the transaction log. This log is not normally viewable. You need a third party tool to view this log such as Lumigent Log Explorer.
Select statements are not logged in the database.
When end result are you looking for?
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Donate to Katrina relief
Select statements are not logged in the database.
When end result are you looking for?
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Donate to Katrina relief
- Status
Similar threads
- Question
