Without DDL and sample data, here's my first thought:

SELECT YearRecruited, Hospital, Jan, Feb, Mar, Apr, May,

Jun, Jul, Aug, Sep, Oct, Nov, Dec, MyCounter,

(Jan + Feb + Mar +...

Copied is good. Let us know if you need any additional fodder to help with your case for a more robust solution.

Nevermind. Finally found a link with them listed.

sys.database_mirroring

sys.database_mirroring_endpoints

sys.database_mirroring_witnesses

sys.dm_db_mirroring_connections

Thanks anyway.

dstoltz 35443 (8/18/2014)

---

Thanks everyone - unfortunately, we don't have a DR site, or even a DR server...we have a 4 hour response time support to get the server fixed if...

First, let's try approaching this problem as if it has nothing to do with the VLFs issue, okay?

What is the schedule (if any) of your snapshot agent?

How big are your...

So did Tom answer your question, then?

If so, please mark his post as the solution. If not, please post again and tell us why it didn't work for you.

Jeff Moden (8/16/2014)

---

Evil Kraig F (8/15/2014)

---

Brandie Tarvin (8/15/2014)

---

It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one...

GilaMonster (8/15/2014)

---

Evil Kraig F (8/15/2014)

---

Is it bad that my first question is to the reporting team guy: "Which reports, and what's their SLA's?" while asking the QA person to email...

Evil Kraig F (8/15/2014)

---

Brandie Tarvin (8/15/2014)

---

It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is from the reporting team, and one is a...

I'm thinking about the original post and I think I'd ask questions like this:

It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is...

GilaMonster (8/11/2014)

---

paul.knibbs (8/11/2014)

---

Jeff Moden (8/9/2014)

With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia, explain or...

Have you tried connecting to SQL without the ",<portnumber>" yet?

At my workplace, we had an issue way back when where the port number was required until our networking team fixed...

Igor Micev (8/15/2014)

---

I have already tried with a DDL trigger on instance level to catch the...

Why not just use a LEFT OUTER JOIN to check for existence?

DECLARE @LogId INT, @L INT, @E INT;

SET @LogId = NULL;

SET @L = 17;

SET @E = 9999;

INSERT INTO t...

What about DDL Triggers? Could those rollback any attempt at renaming a database?