Hello RGR'us,

at the beginning of this topic I mentionned that the database was case-sensitive...

So there is no other solution then using a computed column when the database is case-sensitive ans...

Hello RGR'us,

I tried this method on a big table (1 508 468 rows) and it does not take the index.

I tried with the column having this collation Latin1_General_CS_AS and...

Hello Gregory,

For sure, if I find something I'll let you (this forum) knows.

Best regards,

Carl

Hello Gregory,

We had a similar problem (twice) on one of our clients site. One of the parameter name was "corrupted".

We are unable to reproduce it either.

It was on an Update...

RGR'us,

Its always good to have the "big picture". Maybe your solution is applicable in our case but we have to see.

Many thanks

Carl

Hello RGR'us,

Using this approach don't seem to solve the indexing problem...

In fact the proper index is not used.

Maybe the only solution is to have a computed column?

Best regards,

Carl

Thank's RGR'us,

Short and simple.

Sometimes we tend to see things more complicated than it is, I should have thougth to this.

Carl

Thanks RGR'us,

But what if the column must be case sensitive?

Because it is my point, the entire DB is case sensitive.

Best regards,

Carl

I talked with my network guy and we finally found the problem.

TCP/IP was establishing sessions using ports ranging from 1024 to 5000.

But the fact that we were closing our connections...

Will,

When you say much slower, it seem to me that there is a problem somewhere. The difference between TCP/IP and Named Pipes should not be as significant.

Did you verify the...

Ok thanks Chris.

Principals and schemas are new features but it is not well explain in BOL.

When we want to restrict privileges on only one schema for a principals, it seems very...

Sorry its bêta 2 not bêta 3 (mistype).

Hello Farrel,

from Oracle 9.2 documentation:

UNION ALL Example(s)

The UNION operator returns only distinct rows that appear in either result, while the UNION ALL...

Hello Chris,

Tanx for your help.

We are using CTP of june or bêta 3 (the last one).

Best regards,

Carl

No one tried this?

I would appreciate any feedback.

Regards,

Carl