You say 'each load'.  Are you loading your Services table each day?  Why don't you look at getting the LagCategory populated during the load?

You are currently only backing up the data file once per day?  If you have no need to recover to a point-in-time, then consider setting your recovery model to simple. ...

In addition to the questions that Lynn has asked, can you give us some clarification on what 'fast growth' means to you and why you are concerned.  You mentioned having...

For each History column in the UPDATE and INSERT, you'll need to encapsulate the column name with the CAST function and modify the casted datatype to match the datatype for...

In looking at the data types between like columns in your Header and Audit tables, there are many differences where trying to insert Header table values into your Audit table...

Here's your set-based UPSERT (you'll need to add in whatever error processing methods you've standardized or you are used to):

UPDATE APH

SET APH.LEA_Code =H.[District Code],

    APH.District_Name =H.[District Name],

    APH.School_Code...

Best,

This looks to be the UPSERT that you've been working on.  Is there a reason why you've chosen a cursor to do this when so many have warned against...

Keep in mind that this will only give you the very last statement.  If you need to see more, you may need to run Profiler and try to capture everything...

Use DBCC INPUTBUFFER.  If you do not know the SPID responsible for the hang, you may want to either try to narrow the SPID down by reviewing sp_who2 output, or...

Simon,

Why would you use a cursor for this??

Best,

Use Steve's solution or the same solution that you got the last time you posed this question here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=354363

What about your SMTP server, is it your local SQL Server?  Check and see what account the SMTP service is running under. 

I had this same problem not long ago,...

In what context is xp_smtp_sendmail running? SPROC, DTS, SQLAgent?  Is your SQL Server service running under a domain account or local system?

The cannot find file error usually either means that the file does not exist, or that access is denied.  Check the folder and file permissions on the attachment and make...

The INSERT operation will be logged in the transaction log for the database where the data is being INSERTED, in this case LinkedServer2.

First of all, calling an executable from within a trigger would be considered not a 'best' practice.  I would guess that this executable must then connect itself to the DB? ...