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

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