hello,<BR> I am using stored procedure in my project. As in normal<BR>case of connection object we ge proper erro messages like<BR>primary key or foreign key errors on which we can take any<BR>step. But in the case of stored procedure no proper error message<BR>is returned for primary key or foreign key violation errors.<BR>I tried to raise error by raiserror method before inserting <BR>record. I have also tried to return the message by way of<BR>output variable back to asp page but it is not working properly<BR>and it fails when error is ocurred. <BR> My question is how to return proper error messages from<BR>stored procedure on primary key or foreign key voilation<BR>the error messages from<BR>