I've done that. And even tried "Collation Compatible = True" just for fun, with no change in behavior.

I've found that setting "Enable Promotion of Distributed Transactions" = false causes...

I've only been in a position to interview candidates for the past few years or so, but in that short time I've been amazed at how many people I've seen...

Not particularly related to your problem I don't think, but another interesting tidbit I didn't realize...

I don't know when exactly, but somewhere between SQL 2005 and SQL 2012 SSMS can...

Steve Jones - SSC Editor (3/10/2016)

---

Are you using the DAC locally? Maybe show the connection string so we can be sure this is working?

In a cluster, you might need...

I think logon triggers don't fire when you use DAC (I could be wrong on that), so I'm wondering if you have some other problem going on as well.

You might...

I'm not sure how "good" of a solution it is, but we've had success by creating a SQL Server Agent alert on Error number 1480 (Database replica role change) on...

Maybe a silly question, but are you able to spin up a test SQL 2012 box, put a copy of your data on it, and test against that for awhile?...

We deployed all jobs to both servers, and for jobs we only wanted to run when it's the primary, we added a wrapper around it like this:

IF (SELECT MASTER.DBO.FN_AG_IsPrimary('<AG_NAME>')) =...

bhattpranav (4/9/2015)

---

I tried and it didn't return any rows. I am thinking this may have something to do with the engine? If any knows?

This code executes several 1000 times a...

But as was pointed out above, you don't have DISTINCT...

Perhaps draw attention to standard maint. stuff DBAs do to keep the databases healthy?

I.E. Index Rebuilds, statistics updates, DBCC checks, making sure there are no missing/unused indexes, performing...

You mention you have a mixture of SQL versions, which you would have to upgrade to SQL 2012 to use this feature.

Is it specifically using AlwaysOn Availability Groups...

Eirikur Eiriksson (3/17/2015)

---

The Redneck DBA (3/17/2015)

---

I'm seeing this error pop up occasionally, and am not finding much on the Google about what might be causing it:

Msg 9020, Sev 16, State...

I don't know what the "standard" way to do it is, but we are looking into a similar scenario with our upcoming AlwaysOn implementation.

What I think I'm going to end...

Brandie Tarvin (1/12/2015)

---

And the verdict is in. It was the mirroring after all. Specifically, it was synchronous mode. When I set it to asnychronous, it only took 2 and 1/2...