For some reason out of the blue my database will not allow me to update. I can Insert but can not update. I thought the issue was with my code but when I went to the Management cosole and tried updating a filed I got an error. Data in row was not commit The transaction ended the batch has been aborted Can any one help using SQL 2008 R2

Can you please post the whole error message?

in the Console the error is The data in row 1 was not committed Error Source .Net SqlClient Data Provider. Error message: The transaction ended the trigger. The batch has been aborted. Correct the errors and retry or ESC to cancel change(s). And in quury analyzer Here is what I send UPDATE [Adherents] SET [ContactedBy] = 190 WHERE uid=1117 I get this error. Msg 3609, Level 16, State 1, Line 1 The transaction ended in the trigger. The batch has been aborted. we do not use triggers at all so I am confused. also keep in mind that we can insert but not update. Connected as sa so it's not a permission problem. Thanks for the help www.voipmaroc.com

Are you sure there is no UPDATE trigger on the table? What settings do you have SET IMPLICIT_TRANSACTIONS { ON | OFF }??? Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I am sorry . Where do I check or how do I check this is a 2000 db in 2008 R2 using compatibility mode 2000. Can you guide me please. When I right click and go to manage triggers on this table I find none. www.voipmaroc.com

select name,object_name(parent_id) from sys.triggersBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I got a result for the table in question called trigu but have no clue in 2008 how to view this trigger so that I can copy it here. Can you tell me how please and thanks for the helpwww.voipmaroc.com

Expand Table folder and then click on + near by needed table, then you will see Triggers folder -open itBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

We removed the trigger and the problem was resolved. Thank you for your help. I have no idea how this trigger was added. We checked our SQL 2000 Old db that was on it and it did not have a trigger for this table. Thank you Uri for the help Now I will create a new posting abount installing SQL server 2008 R2 on a server I keep getting an error it fails to install giving me a simple error Boolean TITLE : Error in install program of SQL Server. ------------------------------ The installation program of SQL Server ran into the following error: Method not found : 'Boolean Microsoft.SqlServer.Configuration.MsiExtension.MsiExtensionMetadata.get_IsSlipstreamOrPatch()'.. ------------------------------ BOUTONS : OK ------------------------------ www.voipmaroc.com

You cannot perform a batch transaction which is banned by trigger. This is the cause of the above error because we defined TRIGGER that stops the update batch. To update value in the above table you must drop / disable the trigger & then try updating values. Disable trigger DISABLE TRIGGER <TriggerName> ON <TableName>;http://uk.linkedin.com/in/ramjaddu

I added update to the trigger and it worked then I removed the triger all together whch also worked. I have no idea how this trigger was added when I looked at an old backup of this DB and the specific table, I found out that there was no trigger the trigger was perhaps added lately when we moved from SQL 2000 to SQL2008 I have no idea how. But the issue is resolved thank for the help. www.voipmaroc.com