Re: Who may create a trigger on SYSOBJECTS table
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 06/21/04
- Next message: Danny: "select @version"
- Previous message: kirk cooper: "Is there a way to indentify when a index was created?"
- In reply to: Boaz Ben-Porat: "Who may create a trigger on SYSOBJECTS table"
- Next in thread: Raymond D'Anjou \(raydan\): "Re: Who may create a trigger on SYSOBJECTS table"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Jun 2004 16:33:00 +0100
>From Books Online:
"A trigger cannot be created on a temporary or system table, although
triggers can reference temporary tables. System tables should not be
referenced; use the Information Schema Views instead."
If you want to log creation of objects you could create a Job that regularly
polled the Info Schema views at suitable intervals. Alternatively, if this
is intended as a method of configuration management, you can use various
third-party tools to compare two database schemas and retrospectively
identify any changes that have been made.
-- David Portas SQL Server MVP --
- Next message: Danny: "select @version"
- Previous message: kirk cooper: "Is there a way to indentify when a index was created?"
- In reply to: Boaz Ben-Porat: "Who may create a trigger on SYSOBJECTS table"
- Next in thread: Raymond D'Anjou \(raydan\): "Re: Who may create a trigger on SYSOBJECTS table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
