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

That feature is from SQL Prompt, not the native intellisense.

Redgate Software makes and sells SQL Prompt.

Disclosure: I work for Redgate.

I just use Active Threads and check periodically. The 2012 General and 2014 Admin (and Programming General) seem to be targets for spam for some reason. Not sure why. Those...

A diff is used to save time. If you can do a full + log in your maintenance window, I diff likely doesn't help. Usually we do a diff if...