Post reply

INFORMATION_SCHEMA.TRIGGERS ?????

  • February 17, 2006 at 10:00 am

    #111908

    I cannot find anything like it in SQL 2000. INFORMATION_SCHEMA.ROUTINES only shows me sp's and fn's. Can anyone shed some light?

  • February 17, 2006 at 11:05 am

    #621753

    I'm not sure I understand the question.  This comes from BOL, maybe it will help: 'Contains one row for each stored procedure and function accessible to the current user in the current database. '

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • February 17, 2006 at 11:08 am

    #621755

    but not Triggers

  • February 17, 2006 at 11:16 am

    #621757

    SQL Server 2000 does not include triggers in any of it's INFORMATION_SCHEMA's.  Try using the system tables:

    select * from sysobjects where type = 'TR'

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • February 17, 2006 at 11:50 am

    #621770

    awesome! Is there any way to view the definition of the trigger?

  • February 17, 2006 at 12:24 pm

    #621778

    sp_helptext trigger_name_here

    go

     

  • February 17, 2006 at 12:44 pm

    #621787

    thanks y'all..I can take it from here

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply