Thanks a lot, Lowell. The result did come back as 0. 🙁

I'll talk to the mail guys and see if they have a white list or if there are any...

Thanks for the input.

I checked the SQL Server Agent and the mail profile is enabled for the Alert System.

There is no error message in the mail tables either.

The SMTP...

Thanks, Alan.

I have already set up single instances of SQL in AWS, but now looking to build redundancy for HA/DR. We use EC2 instead of RDS.

SQL clustering is only supported...

Thanks for asking. Here's the error message:

"Exception has been thrown by the target of an invocation."

I know it has to be a permission issue because the job runs fine under...

Thanks, guys. Guess I was not reading.

I checked my package setting, and it was EncryptSensitiveWithUserKey. I don't have any sensitive info stored in the package, so it really shouldn't...

Thanks for your advice and recommendations, David!

Funny you mentioned "AWS provided a hyper-mega-ultra-super-DB server" - even now they still don't have super powerful sql server instance types, IMO. Luckily...

OK, I finally got this to work, thanks to jan.lausch

in this post: http://www.sqlservercentral.com/Forums/Topic1700561-2799-1.aspx

The problem is apparently a hidden broken reference which worked in 2008 but not in...

OK, I finally got this to work, thanks to jan.lausch

in this post: http://www.sqlservercentral.com/Forums/Topic1700561-2799-1.aspx

The problem is apparently a hidden broken reference which worked in 2008 but not in...

Sorry about the repeated posts. Not sure where would be the best place to put it.

I tried everything possible, including recompiling. Nothing works.

The thing is, the job can run the...

Thanks for the advice. The thing is, if I'm trying to match both, it gets really expensive with Provisioned IOPS. So I'm trying to find a happy medium.

We have both...

Great info, thanks a lot, sqlsurfing!

Haven't done a full test yet, but instead of disabling [spShowSlowQueries], I think we can fake the two columns that are not available for versions before 2008 R2. spShowSlowQueries is...

As it turned out, the check constraint was modified by a job that did bulk insert. I didn't realize that default behavior for bulk insert turns off check constraint, and...

Thanks, guys. Very good point to use the default trace. Will try that. I remedied the case by reinforcing the constraint check in the stored proc every time before it...

Yes, it's been a while ago. I believe it turned out to be an issue with the IT infrastructure. Our storage systems for the sql server were failing. After the...