Re: Yet another SQL Express SP2 on Vista Problem...

The only question I have is what affect using a non-case sensitive
collation will have on my users. From what I understand it would mean
that things would be sorted case insensitive. I think this should be
ok, but am not sure. What is the default setting for most SQL
installations?

A second follow on question would be is there any way to
programatically or from a command line change the collation AFTER the
installation is complete? I could then specify case Insensitive
collation and then once the install is done change it somehow to case
sensitive.

.

Relevant Pages

  • Re: SQL7: case sensitivity
    ... In SQL Server 7 you specify the collation on the SERVER level (this is ... changed in SQL Server 2000 where you can specify it down to column level). ... which is supposed to store filenames stored on a Unix ...
    (microsoft.public.sqlserver.programming)
  • Re: Are SQL logins case sensitive
    ... > I tried BOL, but it does not specify case sensitive.? ... If you selected a case sensitive collation or a binary collation, ... >> Satish Balusa ...
    (microsoft.public.sqlserver.security)
  • Re: sql2k Collation problems.
    ... You can explicitly specify the collation of the temporary table as ... You can also use the database_default option in the COLLATE clause to ... current user database for the connection instead of tempdb. ...
    (microsoft.public.sqlserver.setup)
  • Re: Collate: Case INsensitive dictionary object names, Case sensitive column values: How To?
    ... e.g the dictionary object names are case INsensitive, ... There is no way to specify different collations for data and metadata, ... from the database collation. ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • RE: sql2k Collation problems.
    ... and variables are assigned the default collation of the database* ... you can specify a default collation for each new database you ... "Change the collation of the master database in SQL Server 2000" section. ...
    (microsoft.public.sqlserver.setup)