Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: sql profiler trace logs question

    Recently one of our database has been corrupted but I'm not sure if sql profiler is running. do you need to run sql profiler in the production server track activities in the production server? and how will i be able to know if sql profiler is already running? tnx in advance

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Code:
    select * from ::fn_trace_getinfo(default)
    
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •