Ok this one is a bit geeky please ignore if you are not oriented that way.
Probably the greatest new feature in Visual Studio 2008 is Linq which allows you to embed SQL directly into your applications (much cooler and even more usefull than it sounds) but there is a bug (more than one I am sure but one I have come across). If you create a stored procedure with an nvarchar(max) as a parameter then LINQ assumes that it does not return a result set just an unitary result