Hi ASP Guru,<BR><BR>I am using SQL Server as my database.<BR><BR>I need to do a lot of validation using store procedure but if the validation failed, I need to alert the user and abort all updates.<BR><BR>May I know how to trap the error message return by store procedure ? Or can a store procedure return a code to my ASP page so that I can handle.<BR><BR>Thanks in advance !