Home Forums SQL Server 2014 Development - SQL Server 2014 sp_send_dbmail truncates when attaching query results. RE: sp_send_dbmail truncates when attaching query results.

  • July 16, 2014 at 4:36 am

    #1729781

    Sean Pearce (7/16/2014)

    I did some investigation and found the problem, XPStar.dll contains a bug.

    File Version 2014.120.2000.8

    Product Version 12.0.2000.8

    Size 409 KB

    As a workaround, and the method I used to prove my findings, was to copy XPStar.dll from my 2012 instance and replace the file on my 2014 instance (after backing up of course). After restarting SQL Server the issue was solved.

    By default the 2012 location is:

    C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn

    and the 2014 location is:

    C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Binn

    Good stuff, thanks for this.

    XPStar.dll was my main suspect, other changes between the two versions looked irrelevant to the problem (discarding openxml, defaulting return values etc..)

    😎