Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A generic update log utility
Message
 
 
À
25/05/2009 03:26:03
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00691699
Message ID:
01401747
Vues:
94
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform