opc.three (1/5/2013)
Not sure I am completely getting the concern, but I thought I would trace a stored proc call from .NET and show what SQL the SqlClient actually generates on the server side whenever a TVP is used. I had done this once before when TVPs first were released but the refresher was nice.
Trying to make it worked across linked servers is the primary problem. I'd assumed since .NET went byval, linked servers would too.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA