Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

sp_send_dbmail truncates when attaching query results. Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2014 4:54 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:57 AM
Points: 906, Visits: 2,868
I see a connect item has been logged

http://connect.microsoft.com/SQLServer/feedback/details/850260/sql-2014-sp-send-dbmail-64kb-query-result-limit




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1592499
Posted Wednesday, July 16, 2014 4:21 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:57 AM
Points: 906, Visits: 2,868
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




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1592978
Posted Wednesday, July 16, 2014 4:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 1,992, Visits: 5,192
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..)

Post #1592980
Posted Tuesday, July 22, 2014 11:16 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:10 PM
Points: 56, Visits: 336
file version 2014.120.2000.8
product version 12.0.2000.8
size 409k
Date modified 2/21/2014 5:20am


Thank you.
Francis S. Mazeika
Human Interface.
Post #1595194
Posted Tuesday, July 22, 2014 11:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:09 AM
Points: 1,992, Visits: 5,192
Francis S. Mazeika (7/22/2014)
file version 2014.120.2000.8
product version 12.0.2000.8
size 409k
Date modified 2/21/2014 5:20am

That is the flawed/bugged version.
Post #1595211
Posted Tuesday, July 22, 2014 1:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:10 PM
Points: 56, Visits: 336
no shit


Thank you.
Francis S. Mazeika
Human Interface.
Post #1595258
Posted Tuesday, July 22, 2014 1:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:10 PM
Points: 56, Visits: 336
What version works?
I tried to copy the dll from sql 2008 and 2012 into 2014 but it did not work.


Thank you.
Francis S. Mazeika
Human Interface.
Post #1595263
Posted Tuesday, July 22, 2014 3:30 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:57 AM
Points: 906, Visits: 2,868
Francis S. Mazeika (7/22/2014)
What version works?
I tried to copy the dll from sql 2008 and 2012 into 2014 but it did not work.
Did you restart SQL Server?




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1595294
Posted Wednesday, July 23, 2014 8:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 1:10 PM
Points: 56, Visits: 336
Yes restarted sql. then restarted the server.


What version is the good version of XPStar.dll?


Thank you.
Francis S. Mazeika
Human Interface.
Post #1595512
Posted Wednesday, July 23, 2014 9:04 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:57 AM
Points: 906, Visits: 2,868
File Version 2011.110.5058.0
Product Version 11.0.5058.0
Size 438 KB




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1595529
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse