Again, tnx for answering.

That sounds familiar, but there was more to it. We had a set of test scripts for measuring the performance. Basically you could turn all options ON...

Tnx for answering.

I have performance issues and the cursors are not going away real soon. They are build in the communication layer of a commercial 3rd party software. I have...

Tnx for answering all.

You are right: under advanced options you can change the destination of database files. It has been a while for me as well since last I installed...

Colx has about 11000 unique values on several million rows.

On being disabled, I don't know, I'll have to check that. Never thought of that.

OK, the real thing:

/****** Object: Index [$13] Script Date: 08/30/2011 08:54:40 ******/

CREATE UNIQUE NONCLUSTERED INDEX [$13] ON [dbo].[ABX$Item]

(

[EAN-Code] ASC,

[No_] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...

OK, here comes:

/****** Object: Index [$13] Script Date: 08/29/2011 14:05:06 ******/

CREATE UNIQUE NONCLUSTERED INDEX [$13] ON [dbo].[Table1]

(

[Colx] ASC,

[Coly] ASC

)WITH

(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...

So, the use of PERCENT is the problem? That's the only difference I notice...

Tnx for the heads-up all. I rarely use view design, but I was lazy this time...

Tnx, this sure is helpful. I wonder though if this is the Real Thing. As I recall this database was designed and build by a private person and had it's...

Use of the index on a varchar will not be (much) slower, other things may be taken into consideration, like maintenance overhead, updates and deletes, diskspace and such. Here is...

Tnx for answering all. I do find it peculiar, that in DESIGN mode the BY ORDER clause is working.

Oh well.

OK, tnx for answering.

I think most modelling tools can do this. I have worked with ERStudio from Embarcadero and PowerDesigner from Sybase, both can reverse engineer, though it sometimes comes with weird solutions.

However,...

You are right, I was thinking of an attach-statement, has no truck here.

Anyways, 2 of the 3 offending databases have been succesfully restored, I will try the 3rd tonight,it's a...

Tnx for answering all.

The number of files are the same for all DB's, 1 .MDF and 1 .LDF.

The logical names are the same on PROD(source) and TST(target). Location is different,...

Right!

Tnx a lot.