Modifying system tables in SQL Server 2005

Hi,
I wanted to know if there is a way to modify the system tables in
SQL Server 2005, and if yes a way to audit these actions.

I tried selecting from the system tables (using a DAC connection),
it allows me to do so, but the profiler doesnt report on this action.
Table queried on : sys.sysschobjs

Thanks
Prasad

.

Relevant Pages

  • Modifying system tables in SQL Server 2005
    ... I wanted to know if there is a way to modify the system tables in ... SQL Server 2005, and if yes a way to audit these actions. ... it allows me to do so, but the profiler doesnt report on this action. ...
    (microsoft.public.sqlserver)
  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiple Instances - Properties tuning
    ... Why do you want to install mutiple instances of SQL Server since you have ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
    (microsoft.public.sqlserver.server)