all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Error Handling


Error Handling Joycese
9/28/2004 5:13:02 PM
sql server reporting services:
Can anyone provide me pointers to how error handling can be done in SQL
Reporting Services?

RE: Error Handling doug
9/29/2004 9:29:01 AM
Are you using sql scripts or Stored procedures?

[quoted text, click to view]
RE: Error Handling Joycese
9/29/2004 10:59:03 AM
We are using SQL Stored Procedures

[quoted text, click to view]
RE: Error Handling doug
9/29/2004 11:09:03 AM
One way of doing it is to insert into an error table in your exception. Then
before exiting the SP, loop through your error table, return the cursor as a
dataset and bind it to a table for display.

[quoted text, click to view]
AddThis Social Bookmark Button