>Hello all.
>We are migrating from SQL6.5 to SQL2000 and it looks like we are encountering some trigger issues.
>
>Triggers that worked well on our SQL6.5 seems to be giving us problems on SQL2000.
>
>Has anyone else had this type of problems in SQL2000?
>
>Thanks.

The problem that you're probably encountering are probably similar to those encountered by VFP users who have upgraded to VFP 8.0.

Beginning with SQL Server 7.0, changes where made to the SQL commands. For example, if the SQL statement has an aggregate function, every other field must be in the GROUP BY clause.

First, I'd check to make sure that this is the problem by setting the compatibility level to 65. If things run as they did before, then this is indeed the problem.

You'll either have to re-write the triggers, and SPs causing the problems, or leave the compatibility level at 65. The latter, however, is not recommended.