Check the SQL Server log - you will probably see messages related to that database stating it is recovering.  The problem here is that you had a long running transaction...

Here is a simple template for sending an attachment in 'Excel' format.  The trick here is to tell Excel that the delimiter in the CSV file is a comma so...

Here is a template I use for simple table based 'reports' sent from SQL Server.  This can be used directly in an agent job - or used in a stored...

Not sure what changes you made to get the package to run - but it is not handling the additional rows.

In Notepad++...

Using Notepad++ you need to show the symbols (View | Show Symbols | View all characters).  Once you have done that - you will be able to see the actual...

Before looking at which tool to use to send an email - you need to build the query to return the results that you need.  If you provide sample data...

Instead of looking at the agent job history - look at the maintenance plan history.  In that history you will find the error that caused the task to fail and...

You cannot perform an index rebuild or reorganize on a read-only secondary.  It doesn't make sense to compare performance of the reorganize process on a system where that process cannot...

Interesting... there are other execute as options that might work, but as you have a working solution not sure it is worth the time to test.

This is a known issue with Excel - and the available solutions I found are:

1. Make sure the first couple of rows have data to the length you need (ie:...

The error is either truncation or a code page issue - are you sure there are no characters in the source Excel file that could be causing issues?

What happens if...

Paul????  :):):)

One more thing you can try is to set the procedure to EXECUTE AS OWNER.  It seems the problem is user context - and maybe forcing the procedure to execute...

You stated the process is an index reorg - how is that going to run on a read-only secondary?  Is this really performing a REORGANIZE or is it performing a...

They actually are NOT affected at the same time.  They are inserted just as they are in any file system.  Just because it's a relational database doesn't change the...