KB Articles

 

KB Article # 9133

Topic/Category: MSSQL

Issue: Schema Changed from dbo to ephesoft

Analysis:

We suspect that upgrade procedure or database creation for ephesoft was not a standard process since our default installer does not specify schema information.

Solution:

This statement will change the schema

 

SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'ephesoft'

 

< Back|KB Main Page | Next KB Article >

Was this article helpful to you?

Walter Lee

Comments are closed.