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

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?

3 Answers
Accepted Answer
Verified by Edwin J. Hoffer, Expert · Reviewed September 2015

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