You may revoke it. Please make sure that there no applications making use of this procedure through public role.

You may find these links useful.

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/

https://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition?wa=wsignin1.0

I believe you are using Excel to import and you might be getting Truncated Text error. If yes, you may find this link useful.

Import Export wizard is the easiest way.

No. You need to have SSIS installed to run it as a job.

You need not reindex system databases, unless you have really a big number of DML operations on them.

You need to write a custom script and send an email based on the criteria.

You may use sp_helplogins to get the login details and the mappings.

Thanks Jonathan ! This one will surely head to the vault !

This is a warning message which means that the data provider that is under use does not publish code pages used for text columns. Please ensure that the values assigned...

I hope you have the logon credentials of the SQL Server Service Account. If the service account has interactive logon privilges, logon to the server with the Service Account Details...

MAXDOP is an option with which you can control the Maximum Degree of Parallelism. Details on the query hint is here

The preferred way of uninstalling is through "Add/Remove Programs" under Control Panel.

This is a generic error. Check if this helps you, even though it is not Teradata but for Oracle

What error message do you get?