SQL Server; change to how an identity column value from a newly inserted row is retrieved from the database engine

When a new record is added to the database finPOWER Connect uses a special query to find the record number (primary key or identity) it was added as. This is used to relate other records to this newly added record.

In SQL Server the query used was backwards compatible with SQL Server 2000.

SQL Server 2005 and higher support a better method of retrieving the identity column from a newly inserted row, so this has been updated for those database versions.

See also knowledgebase article #9784.