I have a delete method for a table that doesn't work when the key from that table is associated with records in another table. When the user attempts to delete a one of these records, a sql exception number 547 is thrown in the data access layer. When this error number is thrown, I want to notify the user of what is going on. I figured I could just store the error number in a session variable and check for it when the code got back to the procedure that called the delete method in the data access layer, but I can't create a session variable there - I guess because it's a seperate class. Anyway, how can I get the error number back to the calling procedure so I can check for it? I'm figuring there is some standard way that people use that I'm not aware of. Thanks.