Groups | Blog | Home
all groups > sql server (microsoft) > january 2007 >

sql server (microsoft) : Modifying system tables in SQL Server 2005



Prasad
1/13/2007 4:38:11 AM
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
Steve
1/22/2007 5:28:59 PM

[quoted text, click to view]

Yes.

A default Profiler trace will trace activity generated by sqlcmd using
a DAC.
AddThis Social Bookmark Button