When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error.

after there was a note on the trigger statement to update data that is not given block BEGIN TRANSACTION in SQL Server 2000 while it had no effect.

Does the complexity of SQL server 2008 which made ​​it should not be violated?
It points what should be considered when migrating from SQL server 2000 to sql server 2008??

thanks for the enlightenment

Member Avatar
LastMitch

When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error.

@fx.eko

Can you post the error code message?

I don't quite understand your view of the error.