Home » Topic » SQL Server log file not accessible, dbcc not really useful, how to analyze?

SQL Server log file not accessible, dbcc not really useful, how to analyze?

Andrew Jackson ~ Modified: September 16th, 2015 ~ ~ 1 Minute Reading

Home › Forums › SQL Server log file not accessible, dbcc not really useful, how to analyze?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 19, 2015 at 10:27 am #679 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    What do you mean by “query got screwed”? Could you provide the available resource?

    September 21, 2015 at 12:35 pm #702 Score: 0
    Stephen West
    Moderator
    4 pts

    not sure, I know when stored proc was called, from my webserver log, now trying to track it down on db logs.

    September 22, 2015 at 12:17 pm #711 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    I got the solution by applying SELECT * FROM fn_dblog(null,null)

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.