How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me.

Answer Posted / bru medishetty

You can use RaiseError or use the TRY CATCH Programming in
the Stored Procedure Code.

Thanks,
Bru Medishetty
www.LearnSQLWithBru,com

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a unique key and primary key?

504


How do I find sql server instance name?

501


Explain the functionalities that views support?

684


What is the syntax for encrypting a column in SQL Server?

546


How do I find the sql server database version?

520






Where can you find the error log information? : sql server database administration

557


In how many ways you can invoke ssrs reports?

99


How to store and query spatial data?

552


What is nonclustered index with included columns ?

540


What is use of dbcc commands?

618


Can you explain what are various ways to enhance the ssrs report?

575


plss anybody specify tha constrian management system in dbms

1564


What is set nocount on and what is set nocount off?

507


Can we call future method from trigger?

500


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

527