I have a requirement where users will specify at login what language they would want the display of labels and data in. I need guidelines on how to implement this on SQL Server. Any help/reference is gratefully appreciated. Thx.
Are you sure that this needs to involve SQL Server? If the language setting is on a per-session basis then it should probably only be stored in a cookie or similar 'object' that handles session state. When fetching data from SQL Server your application then passes in the desired language so that the correctly localized data is returned.