Collation and sort order, etc..

  • New SQL Server 2005 install (Stnd edition with SP2) and the Vendor for the Application Software has these requirements:

    MS SQL Server SP2 with FULL Text Indexing and Natural Language Query. Collation SQL_Latin1_General_CPI_CI_AS; Date settings Month/Day/Year

    When I installed SQL Server I basically installed the Default Collation of SQL_Latin1_General - is that different from their requirements???

    Also, not sure about Natural Languarge Query AND the date settings??? is Natural Language Query installed by default and how do I check or change the Date Settings????

  • Hi

    Default collation is "SQL_Latin1_General_CP1_CI_AS". The date format would probably be the date format of the server.

    "Keep Trying"

  • Thanks.. so it sounds like their requirements are all the defaults when you install SQL Server 2005???

  • Collation certainly is.

    "Keep Trying"

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply