Post reply

SQL Profiler Help!

  • June 17, 2003 at 9:26 am

    #82769

    Help....I have a request to actively run a trace to capture all "sa/dbo" process on our SQL 2k Servers using profiler...I need to see everything from object alterations to users that are logged in with dbo access..I have a basic template down but can't seem to filter the trace down to capture insert,update and deletes by dbo/sa users only?? Any comments would be much appreciated! Thanks for the help!!

  • June 19, 2003 at 7:51 am

    #462123

    If you restrict the SQL username to 'dbo' that will exclude any other users - where the username is actually populated. But if SQl user is null it gets included in the trace whatever you do. Probably best is to capture the trace to a table (see SQl profiler help), then you can search the results via a SQL statement. Beware though - command text may be truncated, and many values are stored as int rather than readable strings - so you have to look in MSDN to translate the values.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

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

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