Post reply

Regarding SQL Server Profiler

  • November 30, 2004 at 1:45 pm

    #84277

    I recently got into a job in which I am working on a development server for which many developers and DBA's have access. I also have access to the application server. I want to create a profiler trace and do some modifications on the application so that I will become familiar with what stored procedures are being called. I want to create a profiler trace in which only the stored procedures that I am calling will be shown and not by other developers and DBA's who also are accessing the same server.

    Could you please let me know what options need to be selected in the trace

    Thanks!

  • November 30, 2004 at 3:30 pm

    #531977

    Hi

    Yes one easy way is configure the trace with the following filters, use:

    databaseid

    loginname

     and exclude all other users in the database

    objectid

    Try this and let me know any doubt

    thnks

    JR

  • December 1, 2004 at 7:40 am

    #532053

    Thanks for your reply JR.

    Could you please clear a few doubts that I have.

    The login for the application, SQL Profiler and the database are all different.When I am trying to use the filter in SQL Profiler, with which login name should I filter.

     

     

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

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