I believe this might get you started.

WITH stalls

AS ( SELECT LEFT(Physical_name, 1) DriveLetter ,

...

I can't find "AUdit Action Type" in an audit. I see an action and a class. Here's a query I'd potentially use:

SELECT *

FROM sys.fn_get_audit_file([Path],

...

In theory you could do something like this:

ALTER DATABASE SnapshotDB1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE SnapshotDB1 MODIFY NAME = SnapshotDB3

GO

ALTER DATABASE SnapshotDB2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE...

Thanks for all the encouragement guys.

Quick update. Had one in-person and one telephone interview last week that both led to 2nd interviews scheduled this week. Still being pretty...

So I just spent about 25 minutes catching up on the thread. Had actually been busy at work and with life in general until today.

Glad to hear Lynn gets...

The weather here in New England has been odd this winter. We'll have a decent sized snow storm roll through (6+ inches), then we'll warm up to close to...

Jeff Moden (1/25/2014)

---

Shifting gears a bit, I've seen a trend starting to develop that will define the next wave of performance and memory problems. Even some people that I...

Hey, but maybe learning to fly would help...

For me a sabbatical, if it needed to be non-work related, would have something to do with sports. Since my oldest son is really into baseball I'd try to...

Hey, all brand new SQLSaturday in a new state- SQLSaturday 293 - Maine. Be among the first to submit to speak, http://sqlsaturday.com/293/callforspeakers.aspx. Especially those of you who...

Grant Fritchey (12/20/2013)

---

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

For...

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

For instance:

on-call...

Denise,

It like your issue is here:

exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Server Profiler - b7e10d24-0864-4609-8149-58bd0dc813d7'

exec sp_trace_setfilter @TraceID, 11, 0, 6, N'MGH\adtnotices'

--> Customization is now completed <--

-----------------------------------------------------------------------------

-- This filter is...

WayneS (12/18/2013)

---

Jack Corbett (12/17/2013)

---

So is that an automatic standby generator or a portable you need to hook up. I have portable that I have to hook up....

WayneS (12/16/2013)

---

Jack Corbett (12/16/2013)

---

WayneS (12/13/2013)

---

Greg Edwards-268690 (12/13/2013)

---

jasona.work (12/13/2013)

---

Ed Wagner (12/13/2013)

---

jasona.work (12/13/2013)

---

OK, where did the year go?

I mean seriously, 12 days until X-Mas? It feels like it was...