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 |
fantasma
Starting Member
8 Posts |
Posted - 2005-10-14 : 05:57:11
|
Hi all.Whilst looking at one of the SQL Server db's I noticed a new table which is a complete copy of one of the other tables in the db. I haven't created this table so I'm a bit curious about it's existance, namely who created it?Is there anyway of finding out the history of the table, or better yet of viewing all the transactions on the database from a specific date. I think that this information is held in the transaction log yet I've no way of reading it. I've looked at the SQL Server logs and they just tell me a db's backup and start-up history.I'm using SQL Server 2000 on Windows Server 2000.Thanks. |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-14 : 06:17:28
|
Running the Profiler is one of the ways so that you can watch each transactionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|