Trigger Problem

• ManojP

  SSC Veteran

  Points: 268

  More actions

  June 27, 2002 at 11:00 am

  #158109

  Hi Friends,

  I don't have much experience in creating trigger in SQLServer. Even I don't know the way I create it correct or not.

  I create the trigger through Stored procedrue. It doesn't show any compilation error. But when I open the table in design view and click on Show dependencies, it display the below error.

  Error 21776[SQL-DMO]The name 'Trig1' was not found in the Trigger collection. If the name is a qualified name, use[] to separate various parts of the name and try again.

  I couldn't resolve this one. Pls help me to solve this.

  Thanks in advance

  cheers

  Manoj

  P.B. No 14337

  Doha - Qatar

  Ph: 4435361

  web:www.fccqatar.com

  
  P.B. No 14337
  Doha - Qatar
  Ph: 4435361
  web:www.fccqatar.com

• danw

  SSCommitted

  Points: 1842

  More actions

  June 27, 2002 at 11:38 am

  #431776

  This might be a bug with enterprise manager. Instead of using EM use the following SQL code:

  This will return all triggers in your database:

  select * from sysobjects where type = 'tr' order by name

  This will return the text of the trigger when called with the name fro the above statement:

  sp_helptext trigger_name

  If there is a space in the name of the trigger you will have to use the following syntax:

  sp_helptext [trigger name]

  Hope this helps,

  DanW