OR:

SELECT

  t.TABLE_SCHEMA

 ,t.TABLE_NAME

 ,tc.CONSTRAINT_NAME

 ,kcu.COLUMN_NAME

 ,kcu.ORDINAL_POSITION

FROM

 INFORMATION_SCHEMA.TABLES t

 JOIN

 INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc

 ON tc.TABLE_NAME = t.TABLE_NAME

 JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu

  ON TC.CONSTRAINT_CATALOG =KCU.CONSTRAINT_CATALOG

  AND TC.CONSTRAINT_SCHEMA =KCU.CONSTRAINT_SCHEMA

  AND TC.CONSTRAINT_NAME = KCU.CONSTRAINT_NAME

WHERE

 tc.CONSTRAINT_TYPE = 'PRIMARY KEY'

ORDER BY

  t.TABLE_NAME

 ,tc.CONSTRAINT_NAME

 , kcu.ORDINAL_POSITION

I also think that at least you should supply a maximum number of factors!

it is very difficult to compute the roots for all avalable values. But if you still want...

Oh and btw I do believe that Celco IS rude, specially with people that come to these forums asking for help and knowledge and happen to mention something that may...

1. Not really the fact is that it still points to the clustered no materr how many columns or which it contains.

2.Sure! the reason for the alters is that those indexes...

It was very marked the difference between picked activity and non pick hours:

When in normal(working hours) could drag the system for about 30min

When scheduled (at night) 5 min will suffice

To be honest those monsters are runned at scheduled times(because Everybody would suffer it if they were ad hoc) and hopefully nobody happen...

Unfortunately, I can't do anything ( posting realated ), I signed a confidentiality agreement and not even the name of the company can be said here

It can be possible to have that many tables (I've dealt with 1000's), I had to deal with the 240 limit many times because of the views of views of views......

I know the feeling. It is almost a law in software:

"There is never time to make it right, there is always time to do it over"

Sorry, I noticed the Double post and as you can see I deleted it

I know that what I am going to say you are not going to like but I feel imperative to be said because in the long run may make your...

Yep! Was on vacation last week.

Lots of rain in FL  but every minute of sun and beach that could be taken ... were taken...

I didn't mean to imply that! ... just that the poster said:

I am thinking of creating a table variable and pass that table variable to the stored procedure

Because #temp is...

AND table variable datatype is not permited as a procedure parameter!

-- create table ids( n int)

-- insert into ids (n) values (7535)

-- insert into ids (n) values (7536)

-- insert into ids (n) values (7537)

-- insert into ids (n) values (7538)

--...