New spin on SQL Server Express management.

Hi there - I asked the question about automated adminsitration on Express and was given some good solutions since it didn't have SSIS which is used to schedule admin tasks.

HOWEVER, unless I am wrong, I think I heard at PASS that in SP2 SQL Server Express will have maintenance plans -- and thus SSIS? Is this true -- can someone fill me in. I was happy when tooling came down to Express and automated maintenance would help as well.

Thanks

Hi LearningDBA,

You're only option for automated admin of an Express instance is to use the Windows Task scheduler to run SQLCMD scripts. I provided a brief demo for a TechNet webcast - http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032294987&EventCategory=5&culture=en-US&CountryCode=US. You can't create Maint Plans against a SQL Server Express instance because it requires SQL Agent.

Thank you,
Bill Ramos

sql