> Obviously its potentially dangerous - but I don't like the MS policy of
taking
> your toys away because somebody else wasn't playing nice with them.
well these change from version to version & building apps based
on them is going to get your butt kicked sooner or later, also some
of these catalog stuff (objects) in tempDB and are sometimes
misleading. these system objects are not always updated in a
"timely" fashion, querying directly will sometimes return inaccurate
results (trying to get row counts directly is one example). the littany
goes on & on. in any case, ms does provide all those metadata sp
(geez, there's a boatload of them) to query these things. check the
BoL there's more sp & xp than you can shake a stick at.
> So as far as you're aware, its not possible? Not even to add triggers etc?
from the BoL:
Note
System tables should not be altered directly by any user. For example,
do not attempt to modify system tables with DELETE, UPDATE, or
INSERT statements, or user-defined triggers.
this was kicked around on one of the sql server lists (forget if it was
2k or 7.0) and i believe that this "recommendation" turns out to be
set in stone.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
