Problem: When previewing a database mobile business object using SQL, the connection is set to chained mode so it can rollback the query after preview. For ASE stored procedures, you may get an error similar to: Execution failed: Stored procedure 'pubs2.dbo.byroyalty' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction