My object-relational mapping library Lafcadio also has triggers in it.
You can check it out at http://lafcadio.rubyforge.org/ . You can write
both pre- and post-commit triggers in Ruby code, and you can even
write automated tests against those triggers if that's your sort of
thing.

Lafcadio was written first for MySQL but I know somebody who's managed
to make use of it with MS SQL Server.

Francis

Guillaume Marcais <guslist / free.fr> wrote in message news:<0C60E21F-9403-11D8-88E9-003065ED1070 / free.fr>...
> Thanx
> 
> Le 21 avr. 04, 19:59, Shashank Date a ñÄrit :
> 
> >
> > "Guillaume Marcais" <guslist / free.fr> wrote in message
> >> Is there a way for a trigger in MS SQL 2000 to fire some ruby code? I
> >> would like to act upon the insertion of some data in the database.
> >
> > Sure ! First make sure that you do not have any important table named
> > RUBY_TEST in the PUBS database and run this in Query Analyzer :
> > -----------------------------------------------------------------------
> > USE PUBS
> >
> > IF OBJECT_ID('RUBY_TEST','U') is not NULL
> >   DROP TABLE RUBY_TEST
> >
> > CREATE TABLE RUBY_TEST(A INT)
> >
> > GO
> >
> > IF EXISTS (SELECT name
> >     FROM   sysobjects
> >     WHERE  name = N'trig_test'
> >     AND    type = 'TR')
> >     DROP TRIGGER trig_test
> > GO
> >
> > CREATE TRIGGER trig_test
> > ON RUBY_TEST
> > FOR DELETE, INSERT, UPDATE
> > AS
> > BEGIN
> >  EXEC master..xp_cmdshell 'c:\ruby\bin\ruby -ve "puts %Q{Hello World}"'
> > END
> >
> > GO
> >
> > INSERT INTO RUBY_TEST VALUES(20)
> > ------------------------------------------------
> >
> >
> >
> >