Category Archives: SQL Server Development

Database Mail – HTML Formatting

I received a request that a user wanted to be notified when Unusual_Event_01 occurred. The information request was beyond the scope of a simple text e-mail, but didn’t require an excel file to be created and dropped. I came up … Continue reading

Posted in SQL Server Development | Tagged , , , | Leave a comment

Temporary Table Scripting

New version: here A new job on our servers started failing with an odd message. Essentially, the problems boiled down to an INSERT INTO causing more problems than it was worth. The temp table in question that was being created … Continue reading

Posted in SQL Server Development | Tagged , , , | Leave a comment