Post reply

SQL Profiler

  • October 27, 2003 at 11:04 am

    #65144

    I am trying to do a trace for a stored procedure in a user database, based on objectid/object name. We also provided a database ID. But evidently we are getting all the queries that are being executed in that database.

    Earlier we tried to do a similar kind of trace for a table, and we were able to do it. But for some reason I am not able to narrow it down to stored procedure.

    OS - Win2k SP4

    SQL - 2000 with SP3a

    Thanks.

  • October 27, 2003 at 1:05 pm

    #479755

    In profiler, go to Properties, filters, expand 'TextData', then 'Like' and put in %sp_procname% where 'procname' is the name of the procedure you want to trace. I do think there should be a little more intuitive way of doing this, but this should work for you.

    My hovercraft is full of eels.

  • October 28, 2003 at 12:26 pm

    #479965

    Thanks a lot for your help. That solution did work for me.

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

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