>>For SQL 2005 and later you can use sys.indexes system view
>>

>>SELECT name FROM sys.indexes
>>	WHERE is_primary_key = 0
>>		AND OBJECT_name(object_id) = 'ArchiveRetrieval'
>>

>
>This is great. It gives me all the indexes without the primary key.
>
>Thanks

You're welcome