Regional Setting in MS SQL

[akhilesh prasad]

hi
I want to know if there is some setting in MS SQL like in Oracle we have NLS_LANG for regional settings.
Please inform me about some reference for further study in this subject.

[aneeshattingal]

I am not sure about Oracle,
In sql server, you can set some properties common to the database by setting the 'language' options, the fearures by changing the language will include
1. currency
2. date format
etc