DDL Trigger works sometimes!

• Jonathan Matt

  SSCarpal Tunnel

  Points: 4027

  More actions

  October 24, 2006 at 1:44 pm

  #97885

  Hello all,

  I have a database level DDL trigger that will propagate ALTER TABLE statements run against dbo.myTable to schema1.MyTable, schema2.MyTable and so on.

  The trigger works for both "ALTER TABLE dbo.myTable ADD columnABC" and "ALTER TABLE dbo.myTable DROP COLUMN columnABC" when these statements are run from query analyzer (or whatever it's called in SQL 2005!).

  However if I try add the column from the GUI I get the error:

  "Unable to modify table.  This SqlTransaction has completed; it is no longer usable."

  I can drop the column from the GUI with no problems.

  Any ideas?

  Thanks

  JM

   

   

• Jonathan Matt

  SSCarpal Tunnel

  Points: 4027

  More actions

  October 26, 2006 at 7:54 am

  #668182

  I still have not figured this out.

  Does anyone have suggestions on debugging a DDL trigger?  Is it possible to step into it from Visual Studio as with a stored procedure?

  Thanks

  JM