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 |
|
kwilliams
194 Posts |
 Posted - 2006-08-15 : 15:23:54
|
| We have a DTS package that runs nightly that exports data from one server to another. Today, one of our table's data was either deleted, or the DTS package didn't fully run. But the DTS package is showing that it ran successfully, and that several thousand records were exported.If a user did delete the table's data, is there a way within SQL Server 2k Administration to find out who that was? I believe that our Network Administrator thinks that there isn't a way to do this, but I thought that I'd check anyway...you never know. Thanks for any input.KWilliams-------------------It's the end of the world as we know it...and I feel fine |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-08-15 : 15:25:57
|
| There are LOG viewing tools that you can purchase (not sure if any are free or not for trial) that would read your logfile (assuming it is kept) so that you can see if someone did a delete or truncate from the table in question.Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
 |
|
|
kwilliams
194 Posts |
Posted - 2006-08-16 : 09:34:46
|
| Thanks druer,I'll definitely check those out. Thanks for the reply.KWilliams-------------------It's the end of the world as we know it...and I feel fine |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-16 : 11:25:43
|
you could try undocumented functio ::fn_dblogif it helps you.select l.* FROM ::fn_dblog (DEFAULT, DEFAULT) l join sysobjects so on so.name = l.[transaction name] Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Is this possible in SQL Server 2k?