Shaun,

What is the exact error you are receiving?

Going into Control Panel -> Admin tools -> ODBC and starting the steps of creating an ODBC will list what drivers you have...

FYI: He said to group by the count of actors, not by the title.

EDIT: Look up the HAVING clause.

If I'm not mistaken, the script generator is including that in the ALTER statements because the FK was created without the "WITH CHECK" option. I am fairly certain any FK...

Try as I might, I can't seem to get this to work. What really annoys me is those ALTER DATABASE and sp_renamedb messages. Looking at the text of sp_renamedb, it...

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