Re: How do I know if an index column is in descending order from S

Hi Peter

Did you try:

EXECUTE pubs..sp_MShelpindex N'authors', N'aunmind'

John

"Peter Reid" wrote:

> Hey all that I want is to be able to run from another DB.
> This "sp_MShelpindex" like the "indexkey_property" only work running from
> the DB where the index sits.
>
> I need to join this information from multiple DBs in a single query, and I
> was wondering if (and how) this is possible.
>
> Thanks
> 
>
>
>