Nice Post,
seems to be like problem at my end 
I am dong same what you mentions... my problem is... the data which I am passing is not captured inside the procedure.
I checked with profiller it generates textdata which contains sp_executesql and when I do that textdata with EXEC its giving proper outpuy.
here are the text data.
declare @p3 dbo.UserInfo
insert into @p3 values('Imran','Bhadelia')
insert into @p3 values('Abidali','Suthar')
exec sp_executesql N'SP_TestForTable',N'@UserTable UserInfo READONLY',@UserTable=@p3
The procedure will simply select data from coming table. And this will give me 0 rows updated.
when I modify the text and write like following
declare @p3 dbo.UserInfo
insert into @p3 values('Imran','Bhadelia')
insert into @p3 values('Abidali','Suthar')
EXEC SP_TestForTable @p3
, its working fine. Can you please guide me what wrong here?
If you need more details about this problem, please let me know will provide samle applicaiton for the same.
Imran
[MCTS]
Few have audacity to speak truth
http://knowledgebaseworld.blogspot.com/