I'm trying to track down why a db query got screwed in SQL Server. rndbcc log(mydb,2) is not filterable by date(?). And the ldf file I can't access directly without going through 2 layers of bureaucracyrnAny suggestion? How to tackle with it?
SQL Server Log File Not Accessible, Dbcc Not Really Useful, How to Analyze?
Resolved
SQL
CM
Community Member September 16, 2015
3 replies
620 views
Reviewed by moderators
3 Answers
What do you mean by "query got screwed"? Could you provide the available resource?
not sure, I know when stored proc was called, from my webserver log, now trying to track it down on db logs.
I got the solution by applying SELECT * FROM fn_dblog(null, null)n