JDBC Adapter issue with MSSQL 2008


We are working on a database migration from Oracle to MS SQL server 2008 and facing a challenging issue here.

In the new MS SQL 2008 database, the schema name will differ from environment to environment & we have 100+ JDBC adapter services configured via those connections.

We are using the select, insert and update template in which the table names are not displaying under . but showing under .xyz (where xyz is the schema name which differs across the environment).

Is there any settings has to be done in webMethods or Database to show the tables under ?

We tried using Type 4 MS SQL driver and data direct drivers. Both shows the tablenames only under the respective schema.

Could anyone please help me on this?

Many Thanks in Advance!!!

You may need to define the default schema at the MS SQL end.