Problems with collation

Hi,
I have one problem with collation and asp.net 2.0 security. I wrote
about it here:
http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet/browse_thread/thread/7b244e05b30c9eba?hl=en
Can you please look and propose solution.
Nobody from asp.net group responded so I thought that it is more to sql
that to asp.net.
Thanks in advanceHi
There are many posts about changing collation, change the collation for a
database will not change the collations for existing columns in existing
tables. Check out http://tinyurl.com/gxw63 on how to change it at column
level.
You could also run SQL profiler to see what is being executed on the server
and then re-run the statements in Query Analyser to where the error occurs.
John
"milan.letic@.gmail.com" wrote:
> Hi,
> I have one problem with collation and asp.net 2.0 security. I wrote
> about it here:
> http://groups.google.com/group/microsoft.public.dotnet.framework.aspnet/browse_thread/thread/7b244e05b30c9eba?hl=en
> Can you please look and propose solution.
>
> Nobody from asp.net group responded so I thought that it is more to sql
> that to asp.net.
> Thanks in advance
>