These attacks are external. Every day from other ip address, so I'm not able to track it (or it doesn't make sense).

This is a problem. I need this connections because of our external applications.

Maybe I can disable 'sa' account and administer server under another account, but I'm not sure if...

Thanks. And what do you think about performance of this "ASCII(LOWER[name], [name])" ? I plan to use this query on huge amount of text so maybe it'll be very slow.

Thanks...

Currently I have Latin1_General_CI_AI.

Peter

yes, you are right. But I need case insensitive collation and at the same time collation which uses apostrophes.

Thanks

Peter

yes, that works. Annoying for me is fact that binary collation also distinguish small letters and capitals

This query was a little bit simplified.

But it is not possible to use sql_variant and varchar(max).

yes, you are right. CASE is able to return only one datatype and bit has higher precedence than varchar.

So I rewrote the query without CASE function.

Thanks

Hi, few weeks ago I wrote an article in our blog about how to pass an array into stored procedure. You can check it on http://www.syntacticsugar.com/blog/index.php?cat=26