## v4.2.2

#### Added

* DatabaseTasks support for all tasks! Uses FreeTDS `defncopy` for structure dump. Fixes #380.
* Provide class config for `use_output_inserted` (default true) for insert SQL. Fixed #381.


## v4.2.1

#### Fixed

* Guard against empty view definitions when `sb_helptext` fails silently. Fixes #337.
* Proper table/column escaping in the `change_column_null` method. Fixes #355.
* Use `send :include` for modules for 1.9 compatibility. Fixes #383.


## v4.2.0

#### Added

* New `ActiveRecord::Type` objects. See `active_record/connection_adapters/sqlserver/type` dir.
* Aliased `ActiveRecord::Type::SQLServer` to `ActiveRecord::ConnectionAdapters::SQLServer::Type`
* New `SQLServer::Utils::Name` object for decomposing and quoting SQL Server names/identifiers.
* Support for most all SQL Server types in schema statements and dumping.
* Support create table with query from relation or select statement.
* Foreign Key Support Fixes #375.

#### Changed

* The `create_database` now takes an options hash. Only key/value now is `collation`. Unknown keys just use raw values for SQL.
* Complete rewrite of our Arel visitor. Focuing on 2012 and upward so we can make FETCH happen.
* Testing enhancements.
  * Guard support, check our Guardfile.
  * Use `ARTest` namespace with `SQLServer` module for our helpers/objects.
  * Simple 2012 schmea addition and extensive column/type_cast object tests.
* Follow Rails convention and remove varying character default limits.
* The `cs_equality_operator` is now s class configuration property only.
* The `with_identity_insert_enabled(table_name)` is now public.
* Use ActiveRecord tranasaction interface vs our own `run_with_isolation_level`.

#### Deprecated

* n/a

#### Removed

* SQL Server versions < 2012 which do not support OFFSET and FETCH. http://bit.ly/1B5Bwsd
* The `enable_default_unicode_types` option. Default to national types all the time.
* Native type configs for older DB support. Includes the following with new default value:
  * native_string_database_type => `nvarchar`
  * native_text_database_type   => `nvarchar(max)`
  * native_binary_database_type => `varbinary(max)`
* Various version and inspection methods removed. These include:
  * database_version
  * database_year
  * product_level
  * product_version
  * edition
* Removed tests for old issue #164. Handled by core types now.
* The `activity_stats` method. Please put this in a gem if needed.
* We no longer use regular expressions to fix identity inserts. Use ActiveRecord or public ID insert helper.
* All auto reconnect and SQL retry logic. Got too complicated and stood in the way of AR's pool. Speed boost too.
* The adapter will no longer try to remove duplicate order by clauses. Use relation `reorder`, `unscope`, etc.
* We no longer use regular expressions to remove identity columns from updates. Now with `attributes_for_update` AR hook.

#### Fixed

* Default lock is now "WITH(UPDLOCK)". Fixes #368
* Better bind types & params for `sp_executesql`. Fixes #239.

#### Security

* The connection's `inspect` method no longer returns sensitive connection info. Very basic now.