Sorry guys, I forgot to mention that we are modifying this application in its native form : VB6.  So we don't have access to the .Net power

create table #demo (ID int not null primary key clustered, SomeVal int not null)

create unique index IX_Demo on #demo (SomeVal).

Assuming I didn't screw up the syntax this will work. ...

Amen.

Hey this is the first time I post the 100th message on a thread .

I remember asking someone to go work to their place, but apparently there was no opening. 

The good thing is that this project ends this week.  It is also a...

If you still had your test script you could probably easily test it.  So could it but I am under a deadline here so l8r

Thanx for the info (didn't look much into it because) >>

Boss doesn't want the program or server to need access to a shared drive/folder!!

Boss wants a single file for 20...

Care to share the workarounds?? .

Well in 3 years it's the first time I use it... to my regrets.  I think it's nice to know you might use it for some solutions, but unless the...

I know there's a way to do it but I never had to put it in use so I forgot how.

Anyway I don't have much else to offer.  Surely somebody...

Read it again... from a position where you need to create a bad design and that articles starts to make sens (which is what the writter intended iirc).

EDIT

I...

Do you use mixed mode authentication (sql or windows authentication)?

I barely tested that over 2 years ago and only on one setup.  So what I have is pretty inconclusive.  Looks like you got your work cut out for this...

Row by agonizing row (like a cursor).

The opposite of set based.

You can always ask the client if they would agree to first try the express install.  If that fail they can always go buy the full install afterwards.  But I...

Is this field in a relation?

Does this code run?

ALTER TABLE dbo.PATIENT

ALTER COLUMN tx_PatientUniqueCode varchar(125) COLLATE SQL_Latin1_General_CP1_CI_AS not null

If not, what error message are you getting?