You may find these links useful

http://www.sqlservercentral.com/Forums/Topic574316-148-1.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4128e62f-92d1-4125-baa3-fdd9fed59d48

What is the output after executing the above query? Do you see any error messages?

Does the error message read out "expecting a doublecolon"? Why not put a GO keyword after each statement?

Did you try sending the message to yourself without the attachments?

How about creating a text box in the report and assigning an hyperlink to opt-out in that?

Please give the details of the error that you get while installing

Are you able to TELNET that server on the SQL server port?

telnet portnumber

I strongly feel that the content of the job has some problems. Since you have merged two maintenance plans, something has gone wrong during the process.

Could you please open the...

The order can be according to your convenience. There is no hard and fast rule as to which of these should be running first.

Login as SA or any user who has System Admin privileges on that instance. Check the permissions for that database.

If nothing has changed in this query, there is no need to change anything here. Looks like some other query which is executed prior to this is causing the dead...

As per Microsoft documentation is not possible to "uninstall SP3".

You did not post the job step output log. Does it have any information?

Just an FYI. There is a typo. "e" is missing in index.

This will give you the Reserved and Used space details for all the indexes in a table. If this does not meet your requirement, just tweak the query.

...