Thanks for the great infomation.

Perfect!  With that stored procedure I should be able to accomplish what I want.  Thanks for pointing me in the right direction.

I am aware of that method of getting the code to build the indexes.

I need a way within TSQL to get the indexes.

to rephrase: what sql code would I run...

Thanks for responding.  I do have and reference a format file and the first few lines are like this:

8.0

22

1     SQLCHAR    0    72     ","     1     business_name   SQL_Latin1_General_Cp1_CI_AS

2     SQLCHAR    0    70    ...

Thanks to you and "fhanlon" for the help.  The password in question is for SA (no one remembers what it is) and...

Problem resolved.  In searching the net I saw that the problem was possibly caused by having some Borland software installed on my PC.  I figured out that the Borland BDE...

I feel like an idiot and I must be going blind.

Thanks

Russ...

Remi....

Thanks for the reply.  Your SQL skills go far beyond mine (which is not hard to do).  I am going to have to study this code for awhile to understand...

Too, too, simple!

That does the trick.  Thanks for your help