reporting services - Capture the print statement "Messages" in SSRS report in SQL Server -


i have sql server sp (it runs on sql server 2000, 2005, 2008, 2012) returns html code using print statement "messages" not "results"

the html code used build html web page , cannot use select statement due length of characters returned.

i need capture print statement "messages" in ssrs report build web page. if not possible, there way capture in sql server , insert "messages" in temp table?

you can try this: (at end of proc)

create table #msgs (line1 varchar(2000)) insert #msgs  select 'this long msg'+col1 table25  select line1 #msgs 

Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -