Grant,

I've done it in SQL 2000 and SQL 2005.  If you want, we can take this topic offline a bit and see what issues you were having.

Thanks

Sorry for the multiple posts, but our internet connection is acting up and out again!

Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

Use the dbo.sysindexkeys table.  You need to join it to the dbo.sysindexes table.

One thing I would look at first is how you are rebuilding indexes.  If you are doing a drop and create, there is a specific order in which they need...

No, but you can write a function that returns a table.  This function can act as a parameterized view.  I think there is an example in BOL, but don't quote...

try this in the query:

nullif(max(datecol),min(datecol))

I had hoped getting the MA with Space Systems Management would help open doors back down in the Springs in the early 90's, it didn't and that is why I...

I have my degrees too (BS in Computer Science and Business Administration, MA in Computer Information Resource Management and Space Systems Management (Outer Space, by the way)). 

Academia was good, but...

Let's just say we don't see eye to eye.  Having commuted from Colorado Springs to Denver for 15 years, I never really had time to get my MCDBA,  He has...

That is easier said than done.  I won't go into details on that, as it would be inappropriate, and it is only my opinion at this time.  On a parallel,...

ZANGLE is a K-12 Student Information System.

I simplified your query some and ran it against a copy of ZANGLE database.  Take it and make whatever changes you need, but I think this is what you are looking...

Looks like you are running Zangle.  I will look at your query a bit and see what I can do.