MSSQL-Server using wrong schema at update SQL string

TarzanHB posted 1 month ago in General

Moin,

I have a MSSQL-Server with 3 schematas. If I'm trying to update a column of a table over the gui, the generated SQL String always used the first schemata from the database and ignores the schemata from the table. Example. Database contains table like this one here: ho.adress mo.city ro.street Update the mo.city table over the gui and the SQL String looks like this one.

UPDATE "database"."ho"."city" ...

(off course this example with the schemata doesn't make sense, it's only to show the problem ;-) )

Thanks for any help.

Please login to leave a reply, or register at first.