Igor Micev (8/15/2014)

---

...this is the code

ALTER TRIGGER ddl_trig_REname

ON ALL SERVER

FOR RENAME

AS

BEGIN

DECLARE @data XML;

DECLARE @database nvarchar(100);

DECLARE @eventType varchar(50);

...

M Joomun (8/18/2014)

---

Hello both,

Thanks for your replies.

As to the table schema, tblPerson - tblManagementOfBleeding is a 1 ~ 1. I've attached screenshots which give more detail. Do you need anything...

I appreciate the thought. @=)

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...