How to find the current profile required to send an email in SQL Server

Problem You are trying to send an email using “msdb..sp_send_dbmail” but you keep getting one of the following errors: Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107 [Bat...

TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To w...

SSRS Report Viewer Control Broken Image Below Lines – Missing URL parameter: IterationId

I know it is unreasonable for me to say this but AXD files (HTTP Handlers) and anything that has to do with them scares me. I say this because if something goes wrong with them usually you can’t...

New cannot be used on a type parameter that does not have a new constraint

This is not such an obscure problem as it is just not straight forward to solve. Simply put you cannot instantiate a new instance of a generic object without explicitly saying that the method/class yo...