Profiler problem

microsoft.public.sqlserver.tools

12 Sep 2006 2:25 PM

Prasad

Hi Grp
    I have a SQL Server 2005, on which I want to do the following
    1. Audit execute permissions on all the system stored procedure.
    2. Audit select, insert, update and delete on all the system tables.

    Can I do the above ?

    Problems I am facing
    1. For the system stored procedures, though I query from some other
database it shows the database id as 32767 which I later learnt that its the
system resource database.
        (I want to know if it is possible somehow that I get the database id
from which database the stored procedure has been executed)

    2. For the system tables, firstly I cant query the tables using normal
connection, secondly some tables in the master database though system tables
show up as user table, lastly when I connected using DAC I could query the
system tables, but could not audit it (Is there any filter thats blocking
the profiler from showing it or is there any work around so that I can
profile these tables ? )

    If any solution for the above problem or any links and documentation
that says its not possible and why is appreciated.

Thanks
P