I too have wondered how one can alter system tables - what I wanted to do was
add a trigger to the system tables to audit changes to the database structure...
however I was not able to, even though I was using the sa login.
David Cummins
Philip Arnold - ASP wrote:
>
> This might be a dumb question, but is there a way to build an index on a
> system object?
>
> I'm trying to speed up queries on either Information_Schema.Columns or
> SysObjects/SysColumns
>
> It tells me that "ad hoc updates to system catalogs are not enabled"
> Unless one of the switches gets around this...
>
> Any ideas anyone?
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
