MS SQL Trace - historical transactions!

  • Hi,

    I recently started to work for a PR company as a Systems Administrator.

    The accounts application seems to generate duplicate trans or in some cases misses transactions completely! This is due to some of the stored procedures written by an external company... I am trying to monitor the flow of the trans but in most cases I can not duplicate the errors.

    Is there a way where I can set the Profiler to replay historical trans so I can monitor it that way?

    thanks

    V.

  • You can only use Profiler to show what you have already recorded. You can't get it to show something that has already happened. Set it up now to start recording transactions and then stop it and play it back once a day.

    Also, this forum isn't for general questions. It's specifically for the Question of the Day, which is a question sento out via enewsletter. You can also see the QOD by using the menu and going to Resources>Question of the Day.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply