These are the formats the seem to work just fine when entering the parmaters in T-SQL debugger -

{ d 'yyyy-mm-ddd'} for date only

{ ts 'yyyy-mm-dd hh:mm:ss'} for date and...

Yes - I have tried entering -

'12/18/2003 10:30:00', with and without time, single quotes etc. Must be something basic here, just not sure what it is. As a temporary...

Not a problem when actually calling - just trying to use with T-SQL debugger and setting input paramaters. I have tried entering date as mm/dd/yyyy mm:hh:ss and different variations -...

I also have never seen a varible used in this context. Basicaly I have a cursor that will go through each column and do an insert into an audit table...

This is the trigger as it exists today. What I would like to do is only have one insert/select statement, therefore eliminating the if/else and be able to populate the...