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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

John Bell

2005-08-31, 3:23 am

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
>
>
>
>

Sponsored Links