I'm not sure this happened in this case, but small organizations often pay for the developers to construct things in a technically sophisticated way, when there are are other ways...

What is the cost of the audit, and what are the alternatives? The cost aren't just IT costs, but lost business or operations. I'd like to see a switch that...

It looks like a BINARY(9) works

this doesn't work

CASE WHEN [Entered_Dttm] IS NULL THEN 'NULL' ELSE 'CONVERT(DATETIME2, ' + master.sys.fn_varbintohexstr (CONVERT(BINARY(8), [Entered_Dttm])) + ')' END + ', ' +

this does

...

I'm struggling with the datetime2 format.

I get this message:

Msg 8152, Level 16, State 17, Line 1

String or binary data would be truncated.

from this line:

CASE WHEN [Entered_Dttm] IS NULL THEN...

Steve,

Quickly looking through the board, I think I want an additional product, SQL Data Monitor

My employer and the requirements that I give them discretion prevents me from going into much detail publicly.

I actually enjoy social media, so if there are any SQL organizations who...

I have a harder time making this get taken seriously by peers than I do with understanding what the licenses say.

I'm just disappointed the the authors of the articles don't...

It would really depend on your revenue model, and your comfort level in replacing the consultants that left enough of your tools behind for the potential customer to find you.

There...

Brent,

It would seem like an MIT license would be more friendly. Of course, the think I appreciate most about your license is your thoughtful reply to a sincere question.

I appreciate someone pointing out licensing challenges with this script.

Is there a better forum for asking questions about what metrics you can pull back with sql monitor?

I'd particularly like to...