26.03.2021
23:27
Hello everyone,
before you install/upgrade BPS check the default schema of the database user under which the installation/upgrade will be executed. Make sure that the default schema is dbo. If this is a different schema new objects may be created using this schema.
This may lead to unexpected errors later on which will be hard to debug.
Here's a little script to change it.
SELECT name AS [Name],
SCHEMA_NAME(schema_id) AS schema_name,
type_desc,
create_date,
modify_date,
'Alter schema dbo transfer ['+SCHEMA_NAME(schema_id) +'].'+name
from sys.objects
where SCHEMA_NAME(schema_id) not in ('dbo','sys')
I did this in two steps so that I can verify what will be changed.
Best regards,
Daniel
