InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:17:02 GMT20http://www.sqlservercentral.com/Forums/Topic690049-8-1.aspxMatt,I tried by putting the XML schema validation within a nested Try/Catch in the proc and now it's able to capture the LocalError passsed in.Thanks for you feedback.Fri, 03 Apr 2009 16:57:04 GMTbdbahttp://www.sqlservercentral.com/Forums/Topic690049-8-1.aspxAre you spelling the "raise error" correctly? It's "Raiserror", not "RaiseError".Fri, 03 Apr 2009 10:20:06 GMTdmbakerhttp://www.sqlservercentral.com/Forums/Topic690049-8-1.aspxI am trying to Raise an error using RAISEERROR function in sql when the XML schema validation fails.I am doing this inside a store proc. I am declaring the XML doc binding it to it's XSD schema in the TRY block and if validation fails, raise a user define error number by using RAISEERROR function in the catch block. However, somehow i am not able to do this and sql return it's own error the moment it executes that line of code. So using Employee example here, I am doing something like this.CREATE PROC ImportEmployeeInfo@EmployeeXML as XMLASBEGINBEGIN TRYDECLARE @EmpXML AS XML(EmployeeSchema) --declaring a local XML variable and binding it to its XSD Schema CollectionDECLARE @LocalErrorSET @EmpXML = @EmployeeXML -- here I am setting the @EmpXML to @EmployeeXML variable passed inIF @@error<>0 --if the @EmployeeXML failed the XSD validation, i beileve there would be an error right however this line never gets executedBEGINSET @LocalError = 50001 --user defined errorRaiseError(' The input parameter @EmployeeXML is not valid', 16, 1)END--The XML shredding and import into table goes hereEND TRYBEGIN CATCH--I have another another user defined errorhandler proc here which will take the above @LocalError --as input parameter and raise a detailed errorEND CATCHEND --End of ProcFri, 03 Apr 2009 09:40:18 GMTbdba