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 |
|
chapo
Starting Member
39 Posts |
 Posted - 2008-08-28 : 09:27:13
|
| I'm new to SQL and I being ask to write a trigger that will copy each newly created record as is added from the Receiving table located on the FAB database to the qa_receive table on the QPD database after insert on the FAB database. Both databases are located on the same server and the table structure is the same between the two tables. I know that I can create scrip that can copy the data at the user request but they want it to happen instantly, without anyone having to run anything or wait for someone to do it. Any help on how to do this would be greatly appreciated. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
chapo
Starting Member
39 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-28 : 11:47:20
|
Is there anything you don't understand ? What have you try ? post your code here
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
After Insert Trigger