GilaMonster (4/25/2012)

---

A transaction can never be in a state where...

Yes. If the error was such that it left the transaction in a state where it cannot be rolled back, or another inner proc already rolled the transaction back, then...

weiwei_huang (4/25/2012)

---

Hello,

I am new to SSIS. I hope someone can help me and provide SSIS solution for the following requirements:

I need to loop through the following table each month to...

You would need to use a UNION ALL to generate a row containing your column headers, like this:

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'OPC@DOMAIN.COM',

@subject...

Here is a generic create proc template for you that implements TRY/CATCH for exception handling, as the article Gail provided alludes to as the preferred way to implement error handling...

An interesting tidbit...have a look around this page for "bpool_visible"

sys.dm_os_sys_info (SQL 2012)

Any memory DMV experts out there with a minute to have a look?

Difference Between bpool_visible & max server memory

Items like this do not show up in the Default Trace so unless you had some other trace or Extended Events session running to capture activity where you could correlate...

Sorry, my VS2008 is acting up and I am getting the dreaded "Unspecified error" when trying to access a mocked up Excel file to make your examples work. The examples...

I say 24 because I think bp_visible is the amount SQL Server in theory could allocate per the VAS on the server and 192 - 168 = 24...so in theory...

What else is running on the server? Can you account for 24GB of committed memory from processes other than SQL Server's buffer pool?

PS Automatic failover is not supported in Async mode and either way, with mirroring you have to manually keep your logins and other instance-level objects and settings synced.

Have a look at the execution plans. The use of .query adds looping in the first query which explains why it takes so much longer. Both run the CROSS APPLY...

Async mirroring comes to mind first. Enterprise Edition or Standard? Async mirroring (good for separate geo locations or slower links) is Enterprise only.

It also depends on whether you're talking about failing over to a server in the same physical location. I see you're on a WAN...does this mean the failover server is...