In case anyone is still watching this thread...

I come from the "validate all input" school, especially when a "blind" SP is called from who knows where.  Does anyone have any guidance in SS2K on validating the elements in the document before hitting an exception for a "bad date" or "number too large for destination data type" issue?  I've worked out a really clunky way using OPENXML into nvarchar fields, then validate, then parse again into typed fields when the entire doc is valid, but there must be something better