Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A generic update log utility
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00691699
Message ID:
01401747
Views:
96
>This may be unrelated to your question (besides you're not here anymore), but I just learned an interesting thing about passing parameter to a trigger technique, so I'd like to share
>
>You know, at first I wondered what post you were referring to, then I realized that my original post was back in 2002. Those were my younger years (no kids, no grey hair)
>
>The cursor approach didn't affect performance, but yes, it is taxing on the server.
>
>However, the new Change Data Capture in SQL 2008 finally makes it possible to capture changes without having to hand-code solutions. (I started generating scripts for update triggers a few years ago, and I'm sure other developers have built their own routines as well, but CDC in SQL 2008 finally provides a full infrastructure for this)

Hey, dad! She sleeping through the night yet? ;-) (I know she isn't, but I bet she has you wrapped around her little finger already).

It's good to see you back here.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform