Modifying system tables in SQL Server 2005

13 Jan 2007 12:40 PM

Prasad

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

13 Jan 2007 4:29 PM

Andrew J. Kelly

Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See thereply in the other newsgroup.

--
Andrew J. Kelly SQL MVP

Show quoteHide quote

"Prasad" <prasad.e***@gmail.com> wrote in message
news:1168692059.352237.105610@m58g2000cwm.googlegroups.com...
> 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
>

Thread options