Kuntady Nithesh
Reputation: 11721
SQL Server, how to find the operation performed at particular @@dbts
I know that @@dbts time stamp get incremented for each insert , update or delete
Now suppose Select @@dbts gives me 2505.
How can I know which operation (insert/update/delete) is performed when @@dbts is 2504 which caused it to become 2505
Upvotes: 1
Views: 308
Answers (1)
Grant Fritchey
Reputation: 2775
Unless you're monitoring every query call within the system and every one has an output value for the @@DBTS, there's no way to know this.
Upvotes: 2
Related Questions
- Obtain SQL Server executed query history of specific database
- How to track which query in the corresponding stored procedure is executing
- Find machine where a SQL command was run from
- How to find Last executed Query in SQL server
- How to find user activities on a particular database in SQL Server 2000
- Can I check what T-SQL statement had been executed in the database?
- Get all database actions (insert, update , delete, alter, ...)information
- SQL know what queries was executed
- SQL Server 2008 - Finding Specific Commands/Calls/Text
- How do I find all stored procedures that insert, update, or delete records?