Dear All,

Need your advice and suggestion and correct me if i am heading in the wrong direction pls.

In order to resolve this collation conflict, I am intending to do the...

Dear Sugesh,

I tried the "drop login and create it again and try login into the server using that login". The collation conflict still occurs.

Though I didnt see any collation issues...

Dear Dave,

I am sorry to take your time here. I am quite new to SQL 2005.

The issue is I am seeing a collation conflict without doing any query.

Its just pop...

Hi Sugesh,

I am sorry ,I havent done any test yet due to other works on going for me.

The server is at our customer site. I have to wait for their...

Hi Gift,

Thank you for pointing to this. In that case shouldnt it affect the other server with the same collation settings too? But the other servers seems to have no collation...

Hi,

When i checked on the sys.login and etc i didnt see anything on collation. Maybe i am checking the wrong views. But i did a query to extract the collation...

Hi,

I yet to check on the infor you had given. Once I have done I will revert back to you of the outcome.

Thanks again for the help rendered.

Thanks and regards,

chandra

The error message i get doesnt state the table where this error is coming from. Is there a way I can identify from which database or table this error is...

Hi,

Thanks for the swift response...

sorry,

How do i do this " specifying the collate collation name in the from clause of your query."?

how i do this query and where should...