Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
albertalangaram
Starting Member
2 Posts |
 Posted - 2008-01-24 : 08:42:19
|
| Hi All,I have faced the problem in using Triggers(SQL Server 2005 ).While updating the column a trigger fired and moved the records into some other table.But bfore that the transaction is not completed by the server and rolled back the transaction. So that the record is not updated in the first table (otherwise rolledbacked ) and the records are triggerd to the new table.So How Can I take the records after commited the Transaction by the server?.ThanksM.Albert |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-01-24 : 08:46:01
|
| do you have an 'instead of' trigger and you actually want an 'after'?Em |
 |
|
|
albertalangaram
Starting Member
2 Posts |
Posted - 2008-01-24 : 09:41:12
|
| Hi,I Have the following trigger,----------------------------------------------------------------------------------CREATE TRIGGER [dbo].[Triggger] ON [dbo].[Table1] After UPDATE , Insert AS if Update(status) begin IF EXISTS( SELECT 'True' FROM Inserted i WHERE (i.status='D' or i.status='L' ) ) BEGIN .......END------------------------------------------------------------------------When the Status column is upadated the trigger is fired.The Status Column is update using the Java Code with JBoss as the Server. |
|
|
|
|
|
|
Trigeers