RE: Triggers on sysmaster database?

ccremid wrote: > Hello: > > Has anybody created a trigger on the sysmaster database?. > I am thinking on creating an insert trigger on the > syssqlcurses table that will insert the data into another > table in other database. > > I would like to have this trigger running for about a week, > so that I can check all select statements that are run. > > Any opinions? > > TIA > > Tino > Just that it won't work. TFM says quite explicitly that whilst you can = create them, they will never execute, because the SMI tables are not = 'real' - they are mostly information in memory made available through an = SQL interface. I usually say "HTH", but I know that's no help to you at all... ;-) RET +------------------------------------------+ | Richard Thomas | | DBA - Marketing Information Systems | | Optus IT | | email: richard_thomas@yes.optus.com.au | | Ph: +61 2 9342 7188 | | "My opinions are my opinions" | +------------------------------------------+