Problem with non-default schema

[zmarrapese]

YAF does not work correctly when putting in a non-default (ie. non-"dbo") schema.

Example: install\mssql\constraints.sql L1236 is:
exec('[{databaseOwner}].[{objectQualifier}drop_defaultconstraint_oncolumn] {objectQualifier}ActiveAccess, IsGuestX')

This doesn't qualify ActiveAccess with {databaseOwner}.

There are several other areas with the same type of issue.

This can be reproduced by attempting to install YAF on MSSQL Server with a schema of "yaf" defined in the app.config.

[zmarrapese]

In the example above, the issue is not with the calling code because it needs the non-qualified name in order to do a check against sys.objects. The problem is actually in the SP drop_defaultconstraint_oncolumn. It tries to ALTER TABLE without defining the schema.

Also, there are several areas involving BBCode where the schema is not defined.

[w8tcha]

updated the sql files with the missing {databaseOwner}