No, no, no. I didn't mean delete from the system table. That's guaranted to stuff things up.

I meant drop the index.

DROP INDEX <TableName>.<IndexName>

If you try to drop one of those indexes that appears in sysindexes for that table, what happens?

Please don't post multiple threads for the same problem

Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic458367-5-1.aspx

Strange.

Can you run a checkDB on that database? See if there's any form of corruption.

Do you know if anyone there does direct updates of the system tables? check if updates...

Typical management. Tell them straight, there is no 64 bit solution to this problem.

If you have SQL Server 2005, you can rewrite all the DTS packages in SSIS (not...

Please don't cross post. It wastes people's time. Mos of us read all the forums.

Replies to the following thread plase - SSIS Expert

As far as I know, there's no 64 bit compile of DTSRun.

I ran into exactly the same issue when we moved our app onto an Itanium. We had to...

You're ordering by the string conversion of a date, not the date time itself. Therefore 10:24 PM comes before 6:45 AM. (because 1 comes before 6)

If datetimestamp is a datetime...

Please don't cross post. It wastes people's time.

Replies to the following thread please - AWE Settings

I don't know if there's a limitation,and I'm almost scared to ask why you're asking. In general, my opinion on triggers is as few as possible, executing as infrequently as...

What edition of SQL? What OS? 64bit? 32 bit?

Do you have the /pae switch in the boot.ini file?

Did you restart the SQL instance after enabling AWE?

So are table variables. Both will reside only in memory unless there is memory pressure, or the number of rows becomes too large to...

I wrote a short comparison of temp tables and table variables a while back. - Temp tables vs table variables[/url]

Might be of some use.

7 indexes shouldn't slow an insert down that much.

Can you post the code for that step, the table structure and the index definitions please? Also check to see if there...

This should do what you want.

The subquery gets the max date for each parent product. Then join the subquery back to the table on both columns to get the rest...