Comparing triggers in SQL Server 7

• 
  Hello Chris,
  
  In what way do you know the triggers to be different? This will help us look at the right option for fixing the problem.
  
  Thanks!

  Brian Donahue February 15, 2006 15:00

  - 0 +
• 
  Brian,
  
  Thanks for responding.
  Exactly the same triggers exist in my two databases to compare, all I have done is change the text within a single insert trigger on one of the tables that exists in both databases. The table compares as identical and does not notice the text change. I notice there is no icon available for triggers, so I was expected to see the difference noted as part of the table difference (as, for example, it does for table constraints).
  
  Many thanks.

  chrisl February 16, 2006 07:35

  - 0 +
• 
  Can you please double-check your settings to make sure that you haven't simply told SQL Compare to 'ignore triggers'?
  
  Thanks.

  Brian Donahue February 16, 2006 13:45

  - 0 +
• 
  Hello Brian,
  
  it is only wrong with SQL 7.0, in SQL 2000 with the same
  options the triggers will be shown and compared.
  
  nice weekend
  
  Hamu

  Hamu February 25, 2006 07:10

  - 0 +
• 
  Hello,
  
  Yes indeed this is a bug. We have reproduced it here and will have a fix out for it shortly. By the way, this only affects SQL Server 7 and not any other releases of SQL Server.

  Brian Donahue February 27, 2006 12:15

  - 0 +
• 
  Hello Brian,
  
  is this bug fixed in Version 5 and will it be fixed in Version 4 ?
  
  Thank you
  
  Hamu

  Hamu April 08, 2006 06:17

  - 0 +
• 
  I have not been notified about any change in status, so I think the answer is NO on both counts. I'll see if I can find the issue in the system and elevate the priority.

  Brian Donahue April 08, 2006 06:29

  - 0 +
• 
  Ah, my apologies. I was not on the notification list for this. It is fixed and tested, and should work in v5. If you need it for v4, there is an (unreleased) version 4.3 that I can send. If you want it, please send me an email to support@red-gate.com and ask for v4.3 to correct the trigger on SQL 7 problem.
  
  Thanks and sorry for the cunfusion.

  Brian Donahue April 08, 2006 06:33

  - 0 +

Add comment

Please sign in to leave a comment.