What about performance using this methodology?

There are many articles about using "SARG"able methodologies which allow indexes to operate correctly.

http://www.databasejournal.com/features/mssql/article.php/1436301

http://www.windowsitpro.com/SQLServer/Article/ArticleID/42349/42349.html

It appears that the JOIN portion is SARGable, but how...

Wow thanks.

So, from a front end application, I would need to send the "Language String" to all Stored Procedures so wthy would know what language to use ?

Procedure GetPerson(ID_Person int,...

Yes - I WANT to use RAISERROR and I believe it handles multi-languages.  I would like to prove the other assumptions wrong.

If I use sp_addmessage - can I add multiple...

Thanks - pretty much what I figured.

What do you recommend using for bools?

Thanks DC - will read.

A quick note regarding the message board...

Your Hyperlinks are bolding with a moseover and it is nearly impossible to click on them.   Is this something that...