All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
|
Latricia, The change requested by MEDITECH is to
make the SQL Server ‘Case Sensitive’. This is usually something
they request during the DR implementation of the SQL Server box by each site. “CI”
is a SQL Server default during the SQL software installation. Unfortunately, there is only one way which
this can be changed. Delete and re-install SQL Server. If you have databases
already in place, you’d need to do one of two things: (1) Backup the
database using the backup utilities (should be done regardless), or (2) “Detach”
the database on the server with the plan to “Re-Attach” the
database after SQL has been re-installed. The database you re-attach may
remain ‘CI’, so you might need to re-attach the database with a
different name, create a new database with the correct name and transfer the
objects (tables, views, stored procedures, etc.) from one server to another. During the installation of SQL Server, one
of the advanced settings during the install will be to set the collation. You
should be able to find more information either in the installation
documentation or on Microsoft.com Good luck! gmc Garry McAninch
Principal Dimensions Analysis Phone: 905-704-1356 Mobile: 905-941-1356 Fax : 905-688-2256 e-mail: [EMAIL PROTECTED] web : www.dimensionsanalysis.com This communication is intended solely for the addressee(s)
and contains information that is privileged, confidential and subject to
copyright. Any unauthorized use, copying, review or disclosure is prohibited.
If received in error, please notify us immediately by return e-mail. From: dr
[mailto:[EMAIL PROTECTED] Meditech has asked
that we change our collation sequence: SQL_Latin1_General_CP1_CI_AS
should be-> SQL_Latin1_General_CP1_CS_AS So you need to change the "CI" to "CS". Has anyone attempted
this on a server? We would appreciate any suggestions! Latricia A. Hudson Systems Analyst 573-458-7974 Fax: 573-458-8504 [EMAIL PROTECTED]
|
_______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
