The documentation (http://msdn.microsoft.com/en-us/library/ms187658%28v=SQL.100%29.aspx) states:

"You must be a member of the sysadmin role to create and manage maintenance plans, and to view them in Object Explorer."

So it does...

you shouldn't add the check constraint to your partitioned table, but only to the table you use for switching.

The check constraint is needed to ensure, that your non-partitioned table only...

What you really need is an aggregate function that does string concatenation. You can build one in CLR and use it like you would use SUM or AVG. Then your...