Why not just use a server trigger?

I've done so successfully with great success. Even have it email the whole team the name of the offending developer so we can give...

"You can also go for a third party tool for the same purpose"

Why? SQL Server has some reporting built into it. 😎

And can you be certain that the tool you've...

Works with varchar datatype too.

Watch out for when you attempt to output that variable though. If it gets large enough (64K of characters) it'll truncate your output.

I use this approach...

This was an awesome article on many levels. For me it's my first brush with Hyper-V so getting those instructions was GOLD! :w00t:

Second, I'm really excited to see the use...

Good point. In this case we're partitioning by the date because we want to archive old data that isn't necessarily organized. It's an aggreggation from 8 DBs where the they...

Hey Paul,

Really is great to have the guy who wrote the code answering questions. My partition is based on a datetime datatype. Partition works like a...

I got the book here in the States and found some incorrect parts of the SQL DDL for Create Table statements that where in fact ORACLE DDL code - not...

I get the following message:

Ad hoc update to system catalogs is not supported.:w00t:

You can enable output from your script components in the logging section. Make you explictly select the dataflow object in you logging tree. The script component logging option (which appears...

I wonder if we should check the inputrow buffer for a null value and set a flag to redirect the row to an error table of some sort.

Thanks for the heads up on this. I have a task I'm working where this WILL be an issue. Good to have work arounds.:D