Loading ...
Sorry, an error occurred while loading the content.

Re: MUGH-SQLCON sql doubt

Expand Messages
  • mohd rizwan
    Mansoor.....use this query.. USE GO SELECT OBJECTPROPERTY(id, IsTrigger ), name FROM SYSOBJECTS WHERE OBJECTPROPERTY(id, IsTrigger ) = 1 Or
    Message 1 of 4 , Jun 11, 2007
    • 0 Attachment
      Mansoor.....use this query..

      USE <Database_Name>
      GO
      SELECT OBJECTPROPERTY(id,'IsTrigger'), name FROM SYSOBJECTS WHERE OBJECTPROPERTY(id,'IsTrigger') = 1

      Or

      SELECT Name FROM SYSOBJECTS WHERE xtype = 'TR' order by name

      Rizwan........

      shaik mansoor <shaik_mhmansoor@...> wrote:
      Thanks for the response vijay. Is there any other way to find out the triggers that belongs to the a particular database.

      Thanks again for your response in advance.Are u aware of full text catalog in sql server 2000?

      Mansoor.

      vijayasekar shanmughasundharaj <vjsekars@...> wrote:
      sp_helptrigger 'object_name' will give you triggers on a table.

      Thanks
      Vijayasekar

      On 6/6/07, shaik mansoor <shaik_mhmansoor@...> wrote:
      >
      > Hi group,
      >
      > a) where we can see the triggers created for the particular
      > table,generally where the created triggers can be seen in sql server 2000.?
      >
      > b) Is anyone who is having the fair knowlegde about full text catelogs in
      > sql server 2000 can help me out to understand the same or else can you send
      > any good documents on that, becuase I tried in books online but i could not
      > get the concept clearly.
      >
      > Thanks in advance. please respond for this if u r aware of this.
      >
      > Thanks,
      > Mansoor.
      >
      > ---------------------------------
      > We won't tell. Get more on shows you hate to love
      > (and love to hate): Yahoo! TV's Guilty Pleasures list.
      >
      > [Non-text portions of this message have been removed]
      >
      >
      >

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

      ---------------------------------
      Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

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







      Thanks & Regards,
      Mohd Rizwan

      (¨`·.·´¨) Always
      `·.¸(¨`·.·´¨) Keep
      (¨`·.·´¨)¸.·´ Smiling!
      `·.¸.·´


      Send instant messages to your online friends http://uk.messenger.yahoo.com

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.