I've got an app that is running a large number of INSERT statements for a SQL Server database. Occasionally records that should have been inserted do not show up. We can only detect when this happens after the fact, as the program is a compiled Microsoft Executable. I'm wondering if anyone knows of a tool that I can use to monitor a specific SQL Server table as it runs and log any INSERTS that occur.
I know that I could run a trigger but since I'm already questioning the performance aspect so I'd rather not do that. Thoughts? Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:275140 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
