Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Available Indices in remote tables
Message
 
To
15/08/2002 09:50:47
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00689924
Message ID:
00689954
Views:
27
>Thanks George.
>
>I put that statements sequence in a prg and run it, but got a "Class definition sqldmo.sqlserver is not found" error message.
>
>Please note that I don't have SQL Server installed in my PC, perhaps that's the problem, and that's why I need a VFP program do get the indices.
>
Fernando,

That's probably it. SQL-DMO is part of the administrative tools and is very powerful. I don't know of a method, that returns this information. SQLCOLUMNS() comes close, but doesn't appear to indicate whether or not a column is part of an index.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform