Page 1 of 1

Case Sensitive PSDB

Posted: Mon Nov 15, 2004 10:01 am
by PhilHibbs
Is it true that with you have to install Microsoft SQL Server in "Case Sensitive" mode (binary sort order) in order for ProfileStage to work?

Re: Case Sensitive PSDB

Posted: Wed Nov 17, 2004 10:36 am
by PhilHibbs
PhilHibbs wrote:Is it true that with you have to install Microsoft SQL Server in "Case Sensitive" mode (binary sort order) in order for ProfileStage to work?
I'm now convinced that you do need to do this.

I havea colleague with a local install on his laptop, and he used the free Microsoft SQL Server Desktop Engine (MSDE2000A.EXE) and he installed it with default options. Now he needs to re-install with binary sort order; my question is, how do I backup the PSDB database?