Mark,

Thanks for the reply.

I've managed to get the first portion to work although not without some difficulty. I've found a wierd bug, that the package will not run on my...

I'm still playing with this and trying to learn.

The following codeselect distinct db_name(db_id()) DbName,

so.name as 'TableName',ISNULL(si.name,'No Index') as IndexName,

si.index_id,Case When is_primary_key=1 then 'Primary Key Constraint'

Else 'Index' End ConstraintType, si.type_desc,

dbo.udf_GetIndexCol(si.index_id,so.object_id,0)...

Ok, I'm following what Kristoff has done there. I'm still unable to run because of the subquery returning multiple row problem.

Am I correct that having multiple indexes named the same...

Hmm, one saying its not normal, one saying it is!:-D

On the basis that it's normal then, the issue appears to be duplicate index names on different tables. For instance I've...

I'm trying to get to grips with this code as I think parts of it will prove extremely useful. However, i'm rather new to SQL and being a DBA so...

Hi again, and thanks all for your replies.

First of all, a bit of background may make things easier to understand. WE had 65+ Access databases each with at least one...

OK, here's the structure.

[Product Code] nvarchar(10) null

[Maj Gen] nvarchar(5) null

[Nett Price] decimal(18, 2) null

[Disc 1] decimal(18, 2) null

[Disc 2] decimal(18, 2) null

[Date Last Amended] datetime null

[Percentage Increase Date] datetime...