Set Locale of a SQL Server 2005

Question

I am trying to add recaptcha to the code below but i can't :( the contact page it's somethink like that.

submit.asp file :

....
function checktheform(){
    var error_msg = "0";
    if (document.theform.user_lesseename.value==''){
        document.getElementById("lbllessee").style.color = "#fdc110";
        document.getElementById("user_lesseename").style.borderColor = "#fdc110";
        error_msg = "1";
    }
    else{
        ...
        return false;
    }
    else{
        document.getElementById("valid_msg").innerText = '';
        return true;
    }
}

...

<div id="valid_msg"></div>
<form name="theform" method="post" action="sendmail.asp" onSubmit="return checktheform();">
    <input type="hidden" name="sendmail" value="1">
    <table width="490" border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td valign="top">
                 <table width="179" border="0" align="center" cellpadding="2" cellspacing="0" class="submit_air">
                     <tr valign="middle">
                          <td width="175" valign="top"><label id="lbllessee">1. Name of lessee:</label></td>
                     </tr>
                     <tr>
                      ...
                     </tr>
                     <tr>
                         <td valign="top" align="right"><input name="Submit" type="submit" class="form_sub" value="Send" style="cursor:pointer;" ID="Submit1"></td>
                     </tr>
                 </table>

My question is , how i will add recaptcha? or any other captcha method with this coding form ? Do i need to add somehow recaptcha check to checktheform(); function ? and if yes..how ? I was try to add simple captcha which just render the image from google server, but my DATA passed the form ignoring the Captcha field.

Solution

You can set the default language/locale of each user from SQL Management Studio (look under the Security folder).

And override this for a specific connection using the SET LANGUAGE command (or SET DATEFORMAT if you just want to change the date format).

You can also set the default language (used for new users) in SQL Management Studio: right-click on the server, select Properties/Advanced/Default Language.

Comments

[Nick Pickering]

Links are currently broken.

[MauriDev]

@NicholasPickering - thank you for the hint, I found the new link and updated the answer