Toad World® Forums

Alter User Generates Error

I attempted to alter a user, adding the person to several (eight) DB’s simultaneously. I received the following error:

Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS_KS_WS” in the UNION operation.

I somewhat randomly dropped three DB’s, and then the script ran fine.

I forgot to mention that this is the second or third time I have seen this happen. It is reproducible. I am running TOAD 6.5.0.2631.

Apologies for the multiple posts.

After my prior post, I then went and tried to add in the remaining three DB’s. I received the same error when I clicked on the OK button from the User Mapping screen. So, I clicked on the SQL Script tab, and it generated the script just fine. Then I clicked on OK, and it ran fine.

Hopefully this is useful information to you!

Hi,

Thanks so much for your supports. We have reproduce this and create an issue TSS-412. We will follow it. Thanks again.

Kelly Chen