We had a need to have data driven report subscriptions. The only way I found to use the existing subscription functionality was to create a subscription for each potential...

Thanks Hugo for verifying the answers. I couldn't for the life of me figure out what I'd missed.

If you don't want to add in all of the accounts, you could create a group (either in the domain, or locally on the SQL Server box), then add that...

Evgeny Garaev (3/26/2013)

---

Correction, Principal do not wait for commit transaction on the mirror. It waits for transaction being recorded in transaction log file on the mirror server. This is common...

Interesting question.

I knew what the question was asking but got hung up on the wording of the answers for a bit. I think I would have phrased...

CapnHector (3/18/2013)

---

I always use a close parentheses ")" at the top of my code sheets (be careful if you add a go it may not work exactly, tend not to...

Interesting question. In researching this, I was amazed how many posts I found stating that SQL Server needed to be restarted after changing a thesaurus file.

akberali67 (3/18/2013)

---

Hi,

I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in the...

It's been a while, but I changed instances to use a static port on a SQL Server 2008 cluster at my previous job. We had to use static ports...

I assume it is a reference...

Hugo Kornelis (3/14/2013)

---

Locale settings.

Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are NOT a guaranteed...

Hugo Kornelis (3/11/2013)

---

I don't agree. I happened to know this one because I was already using SQL Server...

mike brockington (2/22/2013)

---

I guess some people have difficulty in recognising a little humour when its thrown down!

In reality I would have followed all proper procedures, and given our friend a...

Nice question.

I didn't know the WITH has been optional for hints.

Awesome, thanks for the question on new 2012 functionality.