sqlsrv 7.x-1.0-rc2

Second release candidate for the SQL Server driver for Drupal 7. Now with experimental support for SQL Azure, the cloud version of SQL Server.

Note that updated installation instructions can be found on the project page.

Changes since 7.x-1.0-rc1:

• Rename the database folder to make installation easier.
• Try querying the schema one table at a time to avoid deadlocks.
• Replace the use of the information schema with direct system catalog queries.
• Implement technical primary keys for Azure.
• Add basic tests for primary key handling.
• Move the database files to a separate directory and implement a simple support module.
• Use a direct query to the table in fieldExists() instead of querying the system catalogs to try to reduce lock contention during testing.
• Fix for 'The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.'
• Properly count affected rows, not matched rows to comply to Drupal standards.
• #1027952: expand GROUP BY aliases.
• Workaround Azure obvious limitations.
• Use the new watchdog_exception() now.
• #1050798 by myself: properly rename all the table objects (including primary keys) when we rename a table.
• #1050800 by myself: Workaround SQL Server casting weirdness that make unique index only consider the first 16 characters.