Thank's David,

Really apreciated.

I will now make my own research based in this "new" info.

Best regards,

Carl

Hello David,

Thank's, important to know...

But where it is stated that update statements will take their locks in that order (table followed by index) and select statements will take their locks in...

Thank's for that information. Very helpfull.

Regards,

Carl

It is a "best practice"? I did not know... But it make sense.

Hello Remi,

Yesterday, I've found the solution :

In the trigger I just put SET NOCOUNT ON | OFF embeding the insertion in the audit table and it solve the problem.

Here is...

Hello Remi,

You confirm me that the rturn value of the ExecuteNonQuery() is affected by the variable @@rowcount? Or is it just a guess?

For your question the answer is: It is...

Hello Jamie,

With Oracle you have a lot of flexibility in doing hierarchical queries.

Not only CONNECT BY but also many other analytic functions:

RANK, DENSE_RANK, LEAD, LAG, ... to use with OVER...

http://www.ewebcart.com/cgi-bin/cart.pl?merchant=3122&add=1&item_id=71

Hello Marilyn,

This is not exactly what you want but there is an interesting article in the september/october issue of SQL Server central magazine about a cluster migration from Win2000 to...

Ok Thanks Gregory,

If possible can you post the solution (if MS find something) in order to let everyone benefits from that?

Best regards,

Carl

Hello Gregory,

Have you found something new about that problem?

Thank's

Carl

Hello RGR'us,

Yep... This is why the other solution is also something we will look at (computed columns).

Thanks again,

Carl

Sure...

Just have to modifiy the val column to Latin1_General_CI_AS (case insensitive).

Than rebuild the index on that column (because you have to drop it before modifying the column).

After that just have to...

Hello RGR'us,

Finally found what I was looking for: doing an efficient case-insensitive search in a database that is case-sensitive.

Thank's for your help.

Carl

You need a database with this collation : Latin1_General_CS_AS.

Create a table with only two columns:

Create table test (id int, val varchar(9))

Insert about 100 rows with distinct values for the val...