Create Trigger on sysprocesses table?Permission denied.

[fredong]

I tried to create a trigger on the sysprocesses table and
so I can capture a certain login to a permanent table but I got permission denied an error:
"Server: Msg 229, Level 14, State 5, Procedure TekEcustomerLogin, Line 65535
CREATE TRIGGER permission denied on object 'sysprocesses', database 'master', owner 'dbo'."

Anybody know what is going on? Is it SQL 2000 will not allow you to create trigger on a system table?THanks.

 

[NoCoolHandle]

The simple answer is htat you can't build a trigger on a system table..

 

[fredong]

Anyway I can capture the sysprocesses certain logins to a user defined table?