Short answer: No.

Long answer: When you go through recovery, you apply roll forward and rollback. There's no mechanism to undo these things. A Standby file allows tracking of these items...

S7 (8/10/2016)

---

Thanks, Operational dba. The person didn't have a dba background but came from application support. I'm a senior DBA and the person was hired to help me. Doesn't report...

GlennB (8/10/2016)

---

"Actually, I think this is an issue, especially in large companies that may regularly hire consultants. Who knows what temporary workers might do with information they can gather by...

Sorry, realized I changed your function. You can do it this way as well. Change the join if that's not appropriate for your system

DECLARE @path VARCHAR(500)

SELECT @path = path

FROM...

DECLARE @id INT;

SELECT @id = id

FROM sys.traces

WHERE is_default = 1;

Thanks, lots of ways to do this.

I have tended to quickly mock things up for demos and short tests with a few CMD files. It's lightweight, nothing to install or...

SELECT *

FROM fn_trace_geteventinfo(@id) EI

INNER JOIN sys.procedures

ON procedures.name = TE.name

Or did you want something else?

OK, so the issue here is you're moving hashing and trying to do comparisons. I think that helps.

However, with your temp data mockup, we'll get different results with newid() than...

David.Poole (8/10/2016)

---

I'm coming to the end of my career and looking back I can see huge amount of data collected, allegedly for auditing purposes, that was never accessed and no...

You can restore a database with a different name.

I don't think I type too hard, but I do miss the old IBM, heavy, beige, clicky mechanical keyboards. I've had a few MS keyboards over the years, and those...

TheFault (8/10/2016)

---

"I think I go through a keyboard every 18-24 months, though the mice seem to last longer."

What the heck are you doing to them? 🙂 Not sure I've ever...

I think this is really hard without specific data. Can you mock up an example of something that doesn't work that's exact?

I'd think that the conversions from varchar to nvarchar...

I've done this in T-SQL, as noted. I get the information and then build an HTML table that is emailed to users. It's easy to do and works well.

PoSh...

If any of you want to write up solutions to some of the questions you've answered, and explain in some detail, we're looking for some T-SQL content to publish. Really...