Lynn Pettis (8/11/2016)

---

Having rules for answering questions makes sense but I have to ask the question, Why? Has as been noted there are several different categories that individuals asking...

Thanks, but really looking for original stuff to publish here. If you'd like to get that in database weekly, send a note to articles@

Ed Wagner (8/11/2016)

---

That's fantastic. Do they have a database migration script or is the one you have in place too old? Please understand I mean no offense in...

jim.donovan (8/11/2016)

---

I am a junior guy myself (and NOT with a DBA background)... but, with an *excellent* senior DBA to learn from (and, it's not the only role he is...

Minor Update: The plan to replace the forums is proceeding. We've narrowed down to a couple companies, though the upgraded version of this forum is really winning. It's vastly improved,...

Sorry, I've wanted this as well. If no new log records, why not?

Not a priority for MS. 🙁

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