Within my cascading deletes, will the clustered indexes between the foreign key constraints speed up the delete or will dropping the clustered indexes improve the delete?

Yeah I already went that route and looked into those. The only maintenance tasks I perform on this database are a few LiteSpeed maintenance plans to do full, differential...

Found it....had to find the bad package in sysdtspackages90 (using msdb) and execute sp_dts_deletepackage with the name and folderid....

Wow....talk about obscure

Do you mean from business intelligence studio? How do you open up a maintenance plan in SSIS?

Yep that's it....forgot that was in the management views. Thanks!

That did it.....thanks! 

Thats what I was afraid of....ugh.  It's a shame....some older DB's like Progress allow array datatypes and you can pass in an array of int's to be evaluated in a...

Aaron's fix works pretty well.  I'm going to do some performance testing with CTE's versus the subquery I was using to see how well they match up.  I'll post the...

I tried using CTE's initially but ran into problems when creating the anchor member.  Because it is coming in as a varchar and the member definition is expecting ints for...

Perfect!  Thanks again!

There is an identity column... it would be like:

Identity ID  Value   

-------  --- ------  

5678     16      1       

5679     16      8       

5680     16      1       

5681     16      7       

5682     17      1       

5683     17     ...

DOH!

Joining to the subquery worked.  Can't tell you how many times I have done that in the past for similar queries...

Thanks!

John,

No, it does not exist in one column.  When I created the FT Catalog I selected firstname, lastname and middle initial to be indexed and assumed the engine would be...

Greg,

DTS is fast or slow depending on the types of operations you are performing along with the size of data you are warehousing (not to mention the frequency you are...

well...as long as the app isn't in use after the year 2060 I think this should do it. 

Cool.  Thanks a bunch!