There is a bug in 01.09.02.sql line 113 where you have
IF  EXISTS (SELECT * FROM {databaseOwner}{objectQualifier}sysobjects WHERE id = OBJECT_ID(N'[DF_activesocial_User_Events_LastUpdated]') AND type = 'D')

If you have an objectQualifier, like I have dnn, it would translated to dbo.dnn_sysobjects which is incorrect.

You need to change that line to
IF  EXISTS (SELECT * FROM {databaseOwner}sysobjects WHERE id = OBJECT_ID(N'[DF_activesocial_User_Events_LastUpdated]') AND type = 'D')


Unfortunately if you do have a objectQualifier like I do, this will abend the install and leave tables, stored procedures and functions installed.  Then have to all be deleted manually since Active Social won't be listed in the modules installed.  Each attempt to install ActiveSocial after the above file is fixed will still abend the install due to the previously installed objects.  The only recourse is to one by one delete them unless your SQL kung fu is good and you know how to list the objects for deletion.

This was a known issue that was fixed, but apparently the wrong sql file got added to this latest package. The line was changed to this:

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_activesocial_User_Events_LastUpdated]') AND type = 'D')

You should revert your site to the backup you made before upgrading the module, then run the installation again with the corrected file.

Alternatively, you can install 1.9.5 and then 1.9.6 and it should avoid the problem completely.