I've finally got it figured out. Some code I inherited wasn't defining the commandtype properly. I never would have figured this out without the hints I got here, thanks to...

sam (9/26/2007)

---

I think this should work

exec sp_executesql N'exec sp_UpdateProcessedTrades @vcDeptName, @buySellCoverShortFlag, @customerAccountCounterparty, @shadowAccount, @tradeID',

N'@vcDeptName varchar(5),

@buySellCoverShortFlag varchar(1),

@customerAccountCounterparty varchar(6),

@shadowAccount varchar(4),

@tradeID bigint',

@vcDeptName = 'IF-PM',

@buySellCoverShortFlag = 'S',...

I'm not sure I see what you mean. Are you saying I should be doing this?:

exec sp_executesql N'p_UpdateProcessedTrades',

N'@vcDeptName varchar(5),

@buySellCoverShortFlag varchar(1),

@customerAccountCounterparty varchar(6),

@shadowAccount varchar(4),

@tradeID bigint',

@vcDeptName =...