Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

During the database initialization performed on initial start-up, you could receive the following message:

<pre>
The conversion of a varchar data type to a datetime data type of the value is out of range.
</pre>
Panel
Html bobswift

The problem likely is that the database was created in SQL SERVER Management Studio with a user that has other than English as the default language.

...

To check what default language a server has installed, use the following SQL command:

<pre>
sp_configure 'default language'
</pre>
Panel
Html bobswift

 


If the resulting value is not 0, the default language is not U.S. English. Run the following SQL command to find the installed default language setting and date format used:

html-bobswift
Panel
<pre>
select name ,alias, dateformat
from syslanguages
   where langid =
   (select value from master..sysconfigures
      where comment = 'default language')
</pre>

...


To set the default language to U.S. English, use the following SQL statements:

<pre>
sp_configure 'default language', 0
reconfigure with override
</pre>
Panel
Html bobswift

...


For further details, refer to this Microsoft Support page.

...