We have ported an application from Oracle to SQL Server 2000 and are encountered a problem when calling a stored procedure from our java code. I have a cursor in a stored procedure where I am select from a staging table and doing an insert. If any exception is encountered the stored procedure stops execution all together. However, if I executed the same sp from isql it keeps processing the cursor until completion. This is the behavior I want. Any help is greatly appreciated. Thanks.