SSRS 2005: Display PRINT messages

• jbarker4682

  SSC Journeyman

  Points: 90

  More actions

  February 9, 2009 at 10:55 am

  #201050

  Hello all,

  I am very new to SSRS. I have a stored procedure and I need to verify a few variables during the course of execution, including the exact parameter values being sent to the stored procedure by the report server.

  When I execute the sproc directly from within SQL Server Management Studio, I can see the PRINT messages, but when I run the report from within VS, I'm not seeing them anywhere...

  Is this possible to do?

  Thanks!

  Josh

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 9, 2009 at 11:07 am

  #940673

  You might be better of using raiserror instead of print.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon