The proc will be called all day long with different values for the 300 odd params and actually there will be several sprocs later on with many many params. The...

We will have this sproc with 300 parameters and we don't really need ADO's ability to do type matching for us, so I guess sending the string should make things...

You might want to let us know what the data looks like, the field types and lengths etc. For instance with text fields if you use BCP you do get...

Hey thanks for sharing your ideas.

Andy,

Say they don't send only the changed columns but all the columns, and as you said, you would want to log only the changed columns, which makes perfect sense; specially...

We are looking at just one table as the source of the Event Logging table. Also, we already have a field called datemodified in this table.

The Event log table...

Forgot to add... Logging with stored procs have the added risk that if someone were to go directly to the database and update the table then the change would not...