Member Avatar for fx.eko

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

  • 2 Contributors
  • 1 Reply
  • 292 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by LastMitch
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.