I think the main problems comes from the fact that the string can only be 8000 characters long and that's hard to check while concatenating.

Ya don't do it. Make an sp for each required select in the application and you'll be much better off.

Auditing is exactly why the triggers were created. The task should all be done there. Just add the required insert statement inside the current triggers and you'll be...

Because that's the way it is... also because of mathematical operations. And that's the only answer you'll get from me .

Which one solved your problem?

HTH.

Check out set rowcount in books online.

Can you send out the execution plans of the view version and the table version?

What do you enter?

If only that were true, maybe soon ...

What's mysterious here??

Well you just can't add () just after the select if it's not a derived table.

BTW we knew you weren't gone .

Now that's my kind of girl... married yet ??

count(*)from should have a space. Bot other than that you should be alright (assuming no mathematical formula errors). Where's the problem exactly?

So it means something's corrupt. I'd strongly suggest reinstalling it as there might be some other problems that you haven't discovered yet.