Yep, I tried that but start getting questions on what is the downside for the whole server, etc.

Is there another way to fix that?

Thanks, mj

What will be the way to select the column names as a string in the order they appear in the index?

I tried but with no success...

I need a rust set...

Thanks a lot for the help. I had a bad join between the syscolumns and and the indkeys.

Thanks again, mj

Thanks a lot for the example. I'm already doing that but for German(Phonebook)collation this is still wrong although I call it correctly - it is just wrong sorting...

thanks a lot,...

I have a problem with the binary collation as it sorts all umlauts in the end(after z). The UI application I'm supporting is in Java and has no problem but...

This is not a case of "not wanting to check the data" but more "I could not do it” situation. Most of the time it’s the data, but about 40%...

I do not think that I create any problem - not everything in the DB world is trivial and by the books... and you do not need to be rude,...

I successfully was able to solve this problem on Oracle by using AUTONOMOUS TRANSACTION. What will be the SQL server equivalent to this?

I cannot believe there's nothing... not possible.

Thanks a...

How do you suggest to debug the trigger?

The most common errors are that the audit table has a constraint violation because some other application has already inserted this data by...

I apprecited your replay but it is not up to me to verify if the insert on the auditing table fails and why. I do not have any control over...

I changed the collation with the statement above via alter database. as you could in the example, the setting took effect but the sorting is still the old one -...

Thanks a lot. I have the order by clause, of course - just missed it when typed the post - sorry.

But that still do not help.

As you stated after changing...

Thank you so much! I’m very happy to hear that SQL 2005 might create an internal table from the elements in the “In clauses”. While researching this problem I found...

Thanks a lot for the wonderful comments.

I had a huge fight with the developers of the app, and now they are willing to look and change their code but want...

Thanks a lot for the great ideas.

I need to talk to the application development as it's a 3rd party app and I could only suggest these great ideas. Most likely...