Re: Who may create a trigger on SYSOBJECTS table
From: Raymond D'Anjou \(raydan\) (raydan_at_canatrade.nospamcom)
Date: 06/21/04
- Next message: Ralph Krausse: "Re: SQL slowing down"
- Previous message: Danny: "select @version"
- In reply to: Boaz Ben-Porat: "Who may create a trigger on SYSOBJECTS table"
- Next in thread: Hari Prasad: "Re: Who may create a trigger on SYSOBJECTS table"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Jun 2004 11:20:58 -0400
You can't.
Microsoft does not support triggers on system tables.
"Boaz Ben-Porat" <bbp@milestone.dk> wrote in message
news:%231LbqP6VEHA.2168@TK2MSFTNGP10.phx.gbl...
> Hi all
>
> Is it possible to create a trigger on SYSOBJECT ?
>
> I am logged on as dbo, and trying to create a trigger that executes when a
> table with a specific name is created.
>
> 1) Check if you are DBO:
> select user
> Result: dbo
>
> 2) Create a trigger
>
> CREATE TRIGGER [BBP_SO_AI] ON [dbo].[sysobjects]
> FOR INSERT
> AS
> declare @name sysname
> declare @tp char(2)
> select @name = [name] from inserted
> select @tp = [xtype] from inserted
> if @name like 'BBP%' and @tp = 'U'
> insert into atrace values (1, current_timestamp)
>
> Result:
> Server: Msg 229, Level 14, State 5, Procedure BBP_SO_AI, Line 65535
> CREATE TRIGGER permission denied on object 'sysobjects', database
> 'BBP_TEST1', owner 'dbo'.
>
> Any soloution ?
>
> TIA
>
> Boaz ben-Porat
> Milestone Systems
> Denmark
>
>
- Next message: Ralph Krausse: "Re: SQL slowing down"
- Previous message: Danny: "select @version"
- In reply to: Boaz Ben-Porat: "Who may create a trigger on SYSOBJECTS table"
- Next in thread: Hari Prasad: "Re: Who may create a trigger on SYSOBJECTS table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
