New to SQL Server collation question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • BAK

    New to SQL Server collation question

    From reading other posts, and modifying supplied scripts we have a CS
    server. Our new software package seems to need a CI database. The
    software developer says SQL is not case sensitive and our SQL must be
    broke.

    So ...

    How do I create a new database with enterprise manager with CI?

    We are running MS Windows 2000 Server for Workgroups and MS SQL 2000,
    and have another database app running fine. (That developer set up
    the database.)

    How do I check the collation on the other database?

    Thanks,

    Bruce
Working...