Hi
I recently used this http://drupal.org/node/775804/release recent release for sqlsrv but am now getting an error below.

SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column '__unique_formats' in table 'date_formats' cannot be used in an index or statistics or as a partition key because it is non-deterministic. .

I'm not too sure if my components are compatible but im pretty sure it is, ive been researching this for about 2 weeks now. Kinda stumped. Any help is much appreciated.

Cheers

Comments

damien tournoud’s picture

damien tournoud commented

Hi,

We are not officially supporting SQL Server 2005 yet. And apparently, it doesn't work :)

I am a little bit confused by the error message. Everything in this column is deterministic (it has been designed that way), so I guess something might be confusing SQL Server 2005.

Damien

jgoldfeder’s picture

jgoldfeder commented

Are there any plans for supporting 2005?

jamesodmitchell’s picture

jamesodmitchell commented

subscribing. Also wanting to know if there are plans for supporting 2005.

bryanb229’s picture

bryanb229 commented

Subscribing.

csedev’s picture

csedev commented

Also interested in knowing if there is plan for SQL Server 2005 support.

riggatoney’s picture

riggatoney commented

subscribing

david_garcia’s picture

david_garcia commented
Issue summary: View changes
Status: Active » Closed (cannot reproduce)

Please upgrade your SQL Server Version :)

- and PHP version by the way....