Post reply

Use SQL Profiler to trace calls to a specific stored procedure

  • May 28, 2004 at 10:58 am

    #87500

    I am trying to get a sample file of all the inserts and update operations performed on a particular table in production environment (trying to get a data file for testing in the test server). We have insert and update stored procedure calls from the application. When I run a trace on the server, I get all calls to the server on the trace output window. How do I specify/set a trace filter so that I can get the specific output I am looking for.

    I tried specifying objectname in the filter section while creating the trace but does not seem to work.

    Thanks in advance.

  • May 28, 2004 at 1:30 pm

    #508285

    I couldn't get objectname to work either. I tend to just record them all and then search later in the textdata column for those sql or sps that I am looking for. You can load this data into a table for easy searching.

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

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