Can you not have a small utility table to which you add a login entry
through your app, then use a trigger on this table (before/after insert)
to fire the stored procedure ?

> I need to execute stored procedure on date or on logon.
> Is it possible to create trigger based on some system table to do
> this, and if it is, what system table?

>>No.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com <http://www.upscene.com>
My thoughts:
http://blog.upscene.com/martijn/ <http://blog.upscene.com/martijn/>
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
<http://www.databasedevelopmentforum.com>





[Non-text portions of this message have been removed]