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 |
|
djorre
Yak Posting Veteran
94 Posts |
 Posted - 2009-05-22 : 09:03:20
|
| Hi friends,I got a database which runs parallel to another database using triggers. Every transaction on db1 triggers so that db2 will remain identical to db1.My problem is I want to see if these triggers work. Because if it fails, the transaction is not commited at all. I use an external application to get data in the databases.Is there any way to see some sort of log or error-log, so that I can see if the transactions are done and the triggers have worked? Like the same log you would get out of the query analizer sortalike.dbcc log results are very unclear to me... please help?djorre |
|
|
lightsql
Starting Member
17 Posts |
Posted - 2009-05-26 : 23:39:12
|
| Hi djorre,This is actually not an answer but an advice. It is actually not advisable to use triggers to maintain a constant copy of one database to another, i would recommend though to use transactional replication. In doing so you will have to monitor the replication to see if its up-to-date or running, removing all the necessary troubles of checking the logs every now and then.If you would insist on using triggers though you can create a log table specifically for this purpose. Use your trigger to populate the log table with all the necessary information but remember that triggers is part of your original transaction which will therefore increase the time needed to complete your transaction.Hope this helps! |
 |
|
|
|
|
|
how to view transaction log and transaction errors