I find XE easy to hate.  Sure it's lightweight, but it's tougher to deal with and a pain to get into a table so you can sort through the data...

I think that is still the challenge with things built for "power users". In my experience, most people with the ability and interest to learn are already in their...

D'oh. I forgot there were so many queries on that post, sorry.

--Indexes updated but not read.

SELECT

object_schema_name(i.Object_ID) + '.'+ object_name(i.Object_ID) as Thetable,

i.nameAS 'Index'

FROM sys.indexes i

...

I think maybe there is one bug? Perhaps the script should also be screening out clustered indexes.

One of the most frustrating things in my current job is that I sometimes spend hours rewriting an existing stored proc to eliminate cursors only to find there is little...

Thanks Sue. FailPackageOnFailure was TRUE for some of my executables, but not others, for some reason unknown to me.

Thanks very much, this helped me a ton.

You might check out http://www.pragmaticworks.com/LearningCenter/FreeTrainingWebinars.aspx, they have some pretty good free training on various topics.

Never mind, they spontaneously reappeared.

Has any fix been found for this?? I am experiencing the same problem after a BIDS crashed.

I don't usually open tables in SSMS, I just run queries, but is it possible that you need to page through the results when you open the table?

For anyone still searching, this https://connect.microsoft.com/SQLServer/feedback/details/344393/ssis2005-project-conversion-to-ssis2008-data-sources-are-not-included-in-the-conversion-process provides some answers.