Clever Geek Handbook

How to View Previous Queries in a SQL Server 2000 Database

How to View Previous Queries in a SQL Server 2000 Database

+2


source to share


2 answers


You cannot, unless you control and register them through Profiler. Although if you have something like the Log Explorer, you can view the transaction log and see who updated it. However, this will not show the previously executed SQL.



+2


source


Based on this position , it seems that the use of DBCC LOG (database_name) in SQL 2000 will receive the information of the transaction log. I didn't get a chance to try it myself.



0


source






More articles:


All Articles