Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a trigger on an audit table may cause multiple ent
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01198853
Message ID:
01199710
Views:
15
>>
>>I always appreciate your help along with anyone who wants to offer a suggestion. Sometimes you run into something that provides you with a problem like this one. You have to research, examine all possibilities, ask questions and try different approaches.
>>
>>The suggestion by Stephane resolved the multiple entry problems as well as recording in the audit table any record changed from SQL Query Analyzer or other external means. Now to resolve a few more disasters - one at a time! :)
>
>Hi Tom,
>
>Sorry but I do not believe that 'SELECT *' was the cause of the problem.

Only time will tell. When I put this change into production then it will get a real test! At least right now I am happy, and I can really use a nice dose of feeling good! :)
Previous
Reply
Map
View

Click here to load this message in the networking platform