KFS Fixpack 8 cannot be installed, because DB schema is not dbo

Issue

Latest KFS FP cannot be installed due to DB Schema is unequal to "dbo".

How can I change DB schema for KFS database?

Solution

1.) ALTER SCHEMA NewSchemaName TRANSFER OldSchemaName.ObjectName -> (please notice that ALTER SCHEMA must be done per DB object (Table, SP orView))

2.) User must have appropriate permission to DB

3.) run the KFS SP or FP update

4.) keep dbo schema or change back to old schema, steps are the same as in 1.)

How to change schema of all tables, views and stored procedures in MSSQL:

https://stackoverflow.com/questions/17571233/how-to-change-schema-of-all-tables-views-and-stored-procedures-in-mssql/17571234#17571234

Level of Complexity 

Moderate

Applies to  

References

Add any references to other internal or external articles

​