Dhruvesh Shah (8/1/2011)
My server got hang. but from memory i have setup my instance as US. Can some one pls advise how can i find out what's my default country setting is?
That depends on the account your SQL Server is running in.
Let's assume it's the SYSTEM account:
- Open up the Registry Editor.
- Expand HKEY_USERS\S-1-15-18\Control Panel\International
- If you click on the International key, the regional settings will show for the SYSTEM account.
If you're using a dedicated account with no changes to the default settings, you may go to:
- HKEY_USERS\.DEFAULT\Control Panel\International
If you're using a dedicated account with changes to the default settings, you'll first need to go to:
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList
- Click on any of the S-IDs to find out about the account name (usually to be identified via the ProfileImagePath value) and make a note of the S-ID for your SQL Server account.
- Then go to HKEY_USERS\S-1-15-21-xxxxxxxxx\Control Panel\International
This may not be the most elegant way, but this one definitely works and gives you the results you need.
BTW, the key for the ProfileList will always read \Microsoft\Windows NT\, regardless of the OS your server (or workstation) is running.
-Michael