Toad World® Forums

Create User Error

I attempted to create a new Windows Authenticated user, and 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 ran the create user in TOAD 6.1, and it worked just fine. I can email the appropriate person the 6.1-generated script, if that is needed.

Hi J Fischer,

Thanks for the suggestion,I tried this but cannot got the error,I can create user with

Windonw Authenticated succesful.I am not sure if I do the same step with you.

Could you send me the script generated both 6.1 and 6.5 and attach the reproduce steps?

I will try to find it and then we can fix it.

E-Mail:Cathy.Liu@quest.com

Thanks in advance.

Cathy

Cathy,

Were you able to reproduce the problem with the file I sent you on Monday, Jan 27?