Re: Triggers on system tables

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka@reproms.si)
Date: 04/25/03 

From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si>
Date: Fri, 25 Apr 2003 11:06:10 +0200

> I am running SQL 7.0 and would like to set a trigger on a
> systems table. SQL 7.0 documentation does not say that no
> triggers can be set on system tables (SQL 2000 does ) and
> I tried with no success. The MS suggestion is to set it in
> INformation_schema views. But the table I need to set it
> on has no view. Is there any known way to achieve this?

What do you want to achieve? Maye you should check the Profiler, if you need
to have some kind of auditing, for example. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Relevant Pages

  • ANNOUNCE - Muldis::DB v0.0.0 released, in p5+p6
    ... I am pleased to announce the release of Muldis::DB version 0.0.0 for Perl 5 on CPAN. ... If you want to read all the Muldis::DB documentation that exists now, I recommend doing so in this order: ... Muldis::DB implements a D language as defined by Hugh Darwen and Chris Date, and presents a superior interface for working with the relational model of data, contrasted with SQL. ...
    (perl.dbi.users)
  • Re: Generating SQL
    ... > Scanning a bunch of column descripter classes for column ... a data dictionary documented in code - the value object class. ... > language that is uglier and/or less documented than SQL. ... > cannot find the documentation for your custom query API, ...
    (comp.object)
  • RE: Microsoft Jet SQL Reference
    ... The entire Jet 4.0 SQL Reference is on your hard drive in the following ... > I'm quite challenged by the CONSTRAINT clause documentation. ... > CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER, OrderNotes ...
    (microsoft.public.access.queries)
  • Re: An efficient way to read data from excel
    ... Do you have some URLs for SQL documentation specific to this task? ... Administrator Drivers tab on my computer? ...
    (microsoft.public.scripting.wsh)
  • Re: Generating SQL
    ... a data dictionary documented in code - the value object class. ... >> cannot find the documentation for your custom query API, ... >> of SQL books and resources available. ... >> Any business app programmer who does not know SQL should ...
    (comp.object)