Jeff,

you were perfectly correct with the file extension issue. I was missing the "reverse" approach with T-SQL and that lead us to think of using CLR to be efficient.

With...

Jeff,

I appreciated your contribution very much: you are perfectly right in your statements, including the fact that often there is a shift to CLR due to ignorance on T-SQL (and...

Well,

I know about the ever going discussion on pros/cons, dos/donts between CLR UDTs/UDs and T-SQL ones.

I must admit I am not a fan of religion wars, so I generally follow...

Hi GSquared,

thank you for the suggestion/trick: it seems a reasonable approach.

For what modifications are concerned, yes now application is logging changes in other tables and I knew the trigger "issue".

I...

Thank you Gail for your considerations.

Nevertheless, your approach does not help that much.

You say: add the attributes common to all tables to each table; then use "Script table as" (what's...

Thank you all for your considerations.

I confirm the design is related to OO structure that we have to write in c#: mapping a class to the view instead of having...