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.

Unfortunately, I can't answer that question as we haven't started migrating any of our SQL Server 2000 systems to SQL Server 2005 yet.  All our SQL Server 2005 work is...

The best practice is for those users to have 2 logins.  One admin/dbo and the other just a plain user.  They should use the admin/dbo login only when needed, otherwise...

The only solution I can suggest is to use dynamic sql inside your procedure to build the INSERT statement so you place the keyword DEFAULT in the VALUES clause.

During a...