I get it, it's because this type of error isn't caught by try/catch statements.

If the Rollback transaction is within the Catch Statement, why doesn't the transaction end?

Here's an example script I used for testing this out just now. The table I'm trying...

I missed the Rollback in my psudocode. It does exist in the actual code within the Begin/End Catch statement.

I think you're right about the nested transactions though...

I originally ran...

My Understanding was the limit is 20 cores. You also need to install the specific version of SQL 2012 Enterprise that still allows you to be under the Server...

"Nothing Should", but are you sure nothing is? Run a Profiler Trace against your secondary replica and ensure that is true.

I'm inserting the output of

EXECUTE ('DBCC CHECKDB([' + @DBname + ']) WITH TABLERESULTS');

In 2012 there's additional columns. Trying to make the script I use in 2008 work with...

Microsoft SQL Server Clustering is not used for Load Balancing in the way that I believe you are thinking. It is used for High Availability. For example. Instance...

I shouldn't have said truncates the log file. Rather I want to backup the log file so it empties the contents of the .LDF, preventing it from growing out...

I answered my own questions.

Yes you can do this.

Yes there are restrictions as to the features of the specific SQL Components (SSIS,SSRS,SSAS) by the edition you install.

That error message is almost always related to the "Double Hop" problem. The easiest way to fix it is to make sure all trusted connections are connecting using kerberos...

How does SQL Server itself know how it is licensed? I thought when SQL 2005 came out Microsoft removed the ability to even tell SQL whether it was licensed...

That's it. That was what I needed to do. Thank you for your help!

I spoke with Microsoft support today about my issue. What I have been able to determine so far is that if I create a new text file on my...

Any thoughts?

Primary

replica_server_nameendpoint_urlreplica_server_nameavailability_mode_descfailover_mode_descsession_timeoutprimary_role_allow_connections_descsecondary_role_allow_connections_descbackup_priorityread_only_routing_url

HQFRMDBPRD02\INST1TCP://HqFrmDbPrd02.HQ.CompanyName.LOCAL:5022HQFRMDBPRD02\INST1SYNCHRONOUS_COMMITAUTOMATIC10ALLREAD_ONLY50tcp://HqFrmDbPrd01.HQ.CompanyName.LOCAL:50101

HQFRMDBPRD01\INST1TCP://HqFrmDbPrd01.HQ.CompanyName.LOCAL:5022HQFRMDBPRD01\INST1SYNCHRONOUS_COMMITAUTOMATIC10ALLREAD_ONLY50tcp://HqFrmDbPrd02.HQ.CompanyName.LOCAL:50102

Secondary

replica_server_nameendpoint_urlreplica_server_nameavailability_mode_descfailover_mode_descsession_timeoutprimary_role_allow_connections_descsecondary_role_allow_connections_descbackup_priorityread_only_routing_url

HQFRMDBPRD02\INST1TCP://HqFrmDbPrd02.HQ.CompanyName.LOCAL:5022HQFRMDBPRD02\INST1SYNCHRONOUS_COMMITAUTOMATIC10ALLREAD_ONLY50tcp://HqFrmDbPrd01.HQ.CompanyName.LOCAL:50101

HQFRMDBPRD01\INST1TCP://HqFrmDbPrd01.HQ.CompanyName.LOCAL:5022HQFRMDBPRD01\INST1SYNCHRONOUS_COMMITAUTOMATIC10ALLREAD_ONLY50tcp://HqFrmDbPrd02.HQ.CompanyName.LOCAL:50102