Gotcha This is a problem I have encountered a few times already when using SSIS with an OLE DB Source and a stored procedure. All […]
RedGate SQL Compare – Index was out of range error
Problem This was a weird one because it is clearly a bug in the software. I am running version 13.6.1.7928 Professional of RedGate SQL Compare […]
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, […]
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 […]
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. […]
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 […]