Case Sensitive PSDB

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Case Sensitive PSDB

Post 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?
Phil Hibbs | Capgemini
Technical Consultant
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Re: Case Sensitive PSDB

Post 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?
Phil Hibbs | Capgemini
Technical Consultant
Post Reply