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 |
|
rasher83
Starting Member
24 Posts |
 Posted - 2008-04-23 : 14:40:23
|
| I have a sql server 2005 express database named denisI have several tables in that database.I want to write to a new table, TABLE_1, when there is an insertion on any of the other tables in the database. If i have to create a trigger for each other table separately then fine, but i ideally need something watching all tables for insertions.I have tried adding a trigger unsuccessfully from editing other examples i have seen, so any help you can provide is appreciated.thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-23 : 14:45:20
|
| You must create a trigger on each of the tables that you want to watch.You should show us what you tried and what the error was so that we can help show you where you went wrong.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Need help with triggers.