Viewing 9 posts - 1 through 9 (of 9 total)
These attacks are external. Every day from other ip address, so I'm not able to track it (or it doesn't make sense).
January 2, 2007 at 11:53 am
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...
January 2, 2007 at 7:32 am
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...
August 3, 2006 at 7:42 am
Currently I have Latin1_General_CI_AI.
Peter
August 3, 2006 at 7:16 am
yes, you are right. But I need case insensitive collation and at the same time collation which uses apostrophes.
Thanks
Peter
August 3, 2006 at 6:18 am
yes, that works. Annoying for me is fact that binary collation also distinguish small letters and capitals 🙁
August 3, 2006 at 5:08 am
This query was a little bit simplified.
But it is not possible to use sql_variant and varchar(max).
August 3, 2006 at 2:13 am
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
August 2, 2006 at 1:51 am
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
June 16, 2006 at 3:46 am
Viewing 9 posts - 1 through 9 (of 9 total)