@Sebastian I have gone ahead and dropped all the SPs. All good however the events above remain. There actually is two events that fire each time a user hits the Forum. One is for an AS table and the other for the SP activesocial_Groups_ListMyGroups, this is the only SP that looked like it had been deleted as it was the one missing from the 30 or so that I dropped. I think it all has to do with the AS integration keys for Active Forums still existing somewhere.

InnerException:Invalid object name 'dbo.ald_activesocial_Settings'.
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:System.Data.SqlClient.SqlConnection.
StackTrace:
Message:
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.ald_activesocial_Settings'.

and

InnerException:The stored procedure 'dbo.ald_activesocial_Groups_ListMyGroups' doesn't exist.
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message:
System.InvalidOperationException: The stored procedure 'dbo.ald_activesocial_Groups_ListMyGroups' doesn't exist.

Yes I did have the integration enabled with AF and AS. ATM I'm having issues with AF, can open the Control Panel however the Forum Groups and Forums fail to expand. The Integration is handled in the Features tab of AF although I think the feature has now been removed. I have logged a new issue over on GitHub/Active Forums.

Have looked in the AF tables for a reference to the keys but can't find anything. Seem as though it is the integration that is the cause.